From: | Alban Hertroys <haramrae(at)gmail(dot)com> |
---|---|
To: | Jiří Pavlovský <jira33(at)gmail(dot)com> |
Cc: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: utf8 errors |
Date: | 2013-06-26 14:58:53 |
Message-ID: | CAF-3MvM23gtLbaUz2Y=xz6LfkDSsU9bLqmWp0Fr9nj61xjtNPQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 26 June 2013 11:03, Jiří Pavlovský <jira33(at)gmail(dot)com> 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.
> >>
> >> My database is in UNICODE, client encoding is utf8.
> > Could you run the log message through "od -c" on a UNIX
> > machine and post the result? Maybe there are some weird
> > invisible bytes in there.
> >
> >
> Hi,
>
> I've already tried that before posting. See below for results. Is the
> message in the log the same as the message that postgres receives?
>
>
> 0000000 I N S E R T I N T O r e c i
> 0000020 p i e n t s ( D e a l I D ,
> 0000040 C o n t a c t i d )
> 0000060
> 0000100 V A L U E S
>
>
What bytes are in the above between the closing brace and VALUES? Is that
really white-space? Did you perhaps intentionally put white-space in
between there?
--
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 | Karsten Hilbert | 2013-06-26 15:18:09 | Re: Semi-Pseudo Data Types & Procedure Arguments |
Previous Message | AI Rumman | 2013-06-26 14:55:18 | Re: dynamic partitioning |