Re: utf8 errors - Mailing list pgsql-general

From Jiří Pavlovský
Subject Re: utf8 errors
Date
Msg-id 51CAB1AE.2000900@pavlovsky.eu
Whole thread Raw
In response to Re: utf8 errors  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Responses Re: utf8 errors  (Alban Hertroys <haramrae@gmail.com>)
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.
>

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




pgsql-general by date:

Previous
From: Jiří Pavlovský
Date:
Subject: Re: utf8 errors
Next
From: Sameer Thakur
Date:
Subject: Re: Archiving and recovering pg_stat_tmp