Re: utf8 errors

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