Re: Weird encoding behavior

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Leonardo M(dot) Ramé" *EXTERN* <martinrame(at)yahoo(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Weird encoding behavior
Date: 2009-03-26 15:07:32
Message-ID: D960CB61B694CF459DCFB4B0128514C202FF6511@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Leonardo M. Ramé wrote:
> > As a first step, can you find out the code point of the character that
> > is represented as "?" in your E-Mail?
> >
> > Something like
> > SELECT ascii(substr('NU?EZ', 3, 1));
> > except that instead of the string literal you substitute the column
> > containing the bad value.
>
> I did what you suggested, and it responds with a 63 when the string is
> "NU?NEZ" and 209 when it's "NUÑEZ".

63 is indeed a question mark. Since such a conversion would not be
done by PostgreSQL, "something else" must convert Ñ to ?N *before*
it gets into PostgreSQL...

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2009-03-26 15:15:24 Re: Question about hosting and server grade
Previous Message Marc Mamin 2009-03-26 14:57:12 ltree and full text search questions