| From: | Jiří Pavlovský <jiri(at)pavlovsky(dot)eu> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: utf8 errors |
| Date: | 2013-06-26 09:17:34 |
| Message-ID: | 51CAB1AE.2000900@pavlovsky.eu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sameer Thakur | 2013-06-26 09:25:25 | Re: Archiving and recovering pg_stat_tmp |
| Previous Message | Jiří Pavlovský | 2013-06-26 09:11:05 | Re: utf8 errors |