Re: utf8 errors - Mailing list pgsql-general

From Albe Laurenz
Subject Re: utf8 errors
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17BB6D98@ntex2010a.host.magwien.gv.at
Whole thread Raw
In response to utf8 errors  (Jiří Pavlovský <jiri@pavlovsky.eu>)
Responses Re: utf8 errors  (Jiří Pavlovský <jiri@pavlovsky.eu>)
Re: utf8 errors  (Jiří Pavlovský <jiri@pavlovsky.eu>)
Re: utf8 errors  (Jiří Pavlovský <jira33@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: [HACKERS] Frontend/backend protocol improvements proposal (request).
Next
From: Rory Campbell-Lange
Date:
Subject: array_agg and partition sorts