| From: | Alban Hertroys <haramrae(at)gmail(dot)com> |
|---|---|
| To: | Jiří Pavlovský <jiri(at)pavlovsky(dot)eu> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: utf8 errors |
| Date: | 2013-06-26 10:19:24 |
| Message-ID: | CAF-3MvN9bfMbi_ymcJS-Ke6zmtR9fDzHwkgSk1hXJz-whtz3zw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 26 June 2013 11:17, Jiří Pavlovský <jiri(at)pavlovsky(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jiří Pavlovský | 2013-06-26 10:39:33 | Re: utf8 errors |
| Previous Message | Adarsh Sharma | 2013-06-26 09:50:37 | Re: Concatenate table name in Pl/Pgsql |