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.
>

This is also strange:

 LOG:  statement: INSERT INTO recipients (DealID,
Contactid)                               VALUES (29010, 14340)
 ERROR:  invalid byte sequence for encoding "UTF8": 0xf2 0x2f 0x04 0xa0

next query only with the first value incremented produces different error

 LOG:  statement: INSERT INTO recipients (DealID,
Contactid)                               VALUES (29011, 14340)
 ERROR:  invalid byte sequence for encoding "UTF8": 0x88