| From: | Christoph Berg <cb(at)df7cb(dot)de> |
|---|---|
| To: | Jiří Pavlovský <jiri(at)pavlovsky(dot)eu> |
| Cc: | pgeu-general(at)postgresql(dot)org |
| Subject: | Re: utf8 errors |
| Date: | 2013-06-30 15:31:05 |
| Message-ID: | 20130630153105.GB5789@msgid.df7cb.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgeu-general |
Re: Jiří Pavlovský 2013-06-25 <51C9B98D(dot)6050104(at)pavlovsky(dot)eu>
> Hello,
>
> I have a win32 application. It uses gtk for GUI and postgres. Recently I
> upgraded to newer gtk and postgres 9.2. I'm now getting utf8 errors from
> postgres.
> The thing I don't understand that the queries, which postgres complains
> about, seem to be perfectly valid.
>
> For example
> 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.
0x9c is "STRING TERMINATOR" in the latin1 charset:
http://www.fileformat.info/info/unicode/char/9c/index.htm
Make sure your queries don't contain funky extra chars that are
invisible in the editor.
Christoph
--
cb(at)df7cb(dot)de | http://www.df7cb.de/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2013-07-02 20:54:52 | Reminder, only 20 days left: Call for Papers - PostgreSQL Conference Europe 2013 |
| Previous Message | Jiří Pavlovský | 2013-06-25 15:38:53 | utf8 errors |