Re: Weird encoding behavior

From: "Leonardo M(dot) Ramé" <martinrame(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Weird encoding behavior
Date: 2009-03-26 11:45:45
Message-ID: gqfpo7$12k0$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Well, there *must* be one client that stores wrong data...

You are right, I'll ask someone in site to look at *each* client hunting
for the root of the problem. It must be a Windows Regional Settings or
something similar.

>
> 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.
>
> Yours,
> Laurenz Albe
>

I did what you suggested, and it responds with a 63 when the string is
"NU?NEZ" and 209 when it's "NUÑEZ".

Thanks,
Leonardo.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-03-26 12:32:01 Re: idle connection timeout
Previous Message Grzegorz Jaśkiewicz 2009-03-26 10:54:22 idle connection timeout