Re: utf8 errors - Mailing list pgsql-general

From Alban Hertroys
Subject Re: utf8 errors
Date
Msg-id CAF-3MvN9bfMbi_ymcJS-Ke6zmtR9fDzHwkgSk1hXJz-whtz3zw@mail.gmail.com
Whole thread Raw
In response to Re: utf8 errors  (Jiří Pavlovský <jiri@pavlovsky.eu>)
Responses Re: utf8 errors  (Jiří Pavlovský <jiri@pavlovsky.eu>)
List pgsql-general
On 26 June 2013 11:17, Jiří Pavlovský <jiri@pavlovsky.eu> wrote:
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.

Can you show a \d+ of the recipients table? I suspect there is a trigger attached to inserts on the table or some other side-effect that's causing the issue.

--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.

pgsql-general by date:

Previous
From: Adarsh Sharma
Date:
Subject: Re: Concatenate table name in Pl/Pgsql
Next
From: Jiří Pavlovský
Date:
Subject: Re: utf8 errors