On 06/25/2013 12:18 PM, Jiří Pavlovský wrote:
Hello, I have a win32 application. It uses gtk for GUI and postgres. Recently I upgraded to newer gtk and postgres 9.2. I'm now getting utf8 errors from postgres. The thing I don't understand that the queries, which postgres complains about, seem to be perfectly valid. For example LOG: statement: INSERT INTO recipients (DealID, Contactid) VALUES (29009, 9387) ERROR: invalid byte sequence for encoding "UTF8": 0x9c But the query is clean ascii and it doesn't even contain the mentioned character. My database is in UNICODE, client encoding is utf8.
At a guess your client encoding is actually some form of WINXXXX, most likely WIN1252.
So I'm stuck not knowing where to look for a problem. Thank you, Jiri
-- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
