Re: Weird encoding behavior

Поиск
Список
Период
Сортировка
От Leonardo M. Ramé
Тема Re: Weird encoding behavior
Дата
Msg-id gqfpo7$12k0$1@news.hub.org
обсуждение исходный текст
Ответ на Re: Weird encoding behavior  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Ответы Re: Weird encoding behavior  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Список 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 по дате отправления:

Предыдущее
От: Grzegorz Jaśkiewicz
Дата:
Сообщение: idle connection timeout
Следующее
От: Tom Lane
Дата:
Сообщение: Re: idle connection timeout