Re: utf8 errors

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: Jirí Pavlovský *EXTERN* <jiri(at)pavlovsky(dot)eu>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: utf8 errors
Date: 2013-06-26 08:58:32
Message-ID: A737B7A37273E048B164557ADEF4A58B17BB6D98@ntex2010a.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • utf8 errors at 2013-06-25 19:18:32 from Jiří Pavlovský

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jiří Pavlovský 2013-06-26 09:03:02 Re: utf8 errors
Previous Message Albe Laurenz 2013-06-26 08:33:11 Re: [HACKERS] Frontend/backend protocol improvements proposal (request).