Forum OpenACS Q&A: Re: in OACS.5.2.3, how to get news notification safely?

Collapse
Posted by Brian Fenton on
Hi David,

what database are you running, Postgres or Oracle? What character set is your data stored on the database? Does the character set support the language you're using? You may need to set the correct character set in your AOLserver configuration file also. See here for more info:
https://openacs.org/forums/message-view?message_id=199029

Brian

Collapse
Posted by David Ghost on
My system runs on Postgres
I created db with "-E UNICODE.." switch
I don't know how to check Charset in Postgres.
My AOLServer config file has UTF-8 sets.
Collapse
Posted by Brian Fenton on
Hi David, that all sounds reasonable. In that case, you'll need to investigate further. I would first check that when you save the News items to the database, that they look ok (by using whatever Postgres' equivalent tool to SQL*Plus is). In Oracle there is a very useful function called DUMP which tells you exactly what is stored in each byte (which will then get displayed as characters according to the NLS_LANG environment variable) - I'm sure there must be something equivalent in Postgres. If the data looks fine at that stage, then I would look at the next step in the process, which seems to be the email sending. Look into how the email is generated, and how the data is pulled out of the database.

hope this helps,
Brian