Jirí Pavlovský wrote: > I have a win32 application. > 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. Could you run the log message through "od -c" on a UNIX machine and post the result? Maybe there are some weird invisible bytes in there. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general