Re: Weird encoding behavior - Mailing list pgsql-general

From Leonardo M. Ramé
Subject Re: Weird encoding behavior
Date
Msg-id gqfpo7$12k0$1@news.hub.org
Whole thread Raw
In response to Re: Weird encoding behavior  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Responses Re: Weird encoding behavior
List 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.

pgsql-general by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: idle connection timeout
Next
From: Tom Lane
Date:
Subject: Re: idle connection timeout