On 26.6.2013 10:58, Albe Laurenz wrote: > 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. > > Hi, I've already tried that before posting. See below for results. Is the message in the log the same as the message that postgres receives? 0000000 I N S E R T I N T O r e c i 0000020 p i e n t s ( D e a l I D , 0000040 C o n t a c t i d ) 0000060 0000100 V A L U E S 0000120 ( 2 9 0 0 9 , 9 3 8 7 ) \n 0000136 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
