Re: utf8 errors - Mailing list pgsql-general

From Jiří Pavlovský
Subject Re: utf8 errors
Date
Msg-id 51CAB029.6060306@pavlovsky.eu
Whole thread Raw
In response to Re: utf8 errors  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Rory Campbell-Lange
Date:
Subject: array_agg and partition sorts
Next
From: Jiří Pavlovský
Date:
Subject: Re: utf8 errors