I have created a db WITH ENCODING = 'unicode'.
I have SET CLIENT_ENCODING TO 'unicode'.
Is there anything else I can set to force communication in unicode?
My problem is as follows: I'm making a client application which
functions entirely in unicode utf-8. However, when I write strings
containing accented characters, with INSERT to VARCHAR or TEXT
fields, these characters end up stored as garbage.
This can mean only two things (after narrowing down the problem for 2
days). either the client doesn't write the information to psql in
unicode, or psql (7.3.2) expects something else than unicode.
The support people from my programming environment assure me the
information is being sent as unicode.
That's why I would like to know for sure whether the settings
mentioned above are enough to make psql expect its incoming strings
as unicode. (Or whether there is a known bug around.)