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)