Forum OpenACS Development: News Aggregator encoding problem

Collapse
Posted by Vitor Silva on
Hi, my name is Vitor, and I am newbie in OpenACS world. I've installed news-aggregator package in my site. But I have a problem: the RSS feed is encoding in LATIN 1, and my db is UNICODE. I've changed the file “packages/news-aggregator/sql/postgresql/news-aggregator-create.sql” using the convert function from postgres like this:

create or replace function na_source__new (

...

insert into na_sources (

...
) values (

v_source_id,

p_package_id,

p_owner_id,

p_feed_url,

p_link,

convert(p_title using utf8_to_iso_8859_1),

convert(p_description using utf8_to_iso_8859_1),

p_updates,

p_last_scanned,

p_last_modified

);

That's work for me. But after some time, when News Aggregator make an update, the title and description is write in LATIN 1. I don't find where I can made any modification to fix that. Someone knows something about?

Thanks, Vitor
(Sorry about the bad english)