Re: PgAdmin on Windows - UTF8 and WIN1252

Поиск
Список
Период
Сортировка
От Vik Reykja
Тема Re: PgAdmin on Windows - UTF8 and WIN1252
Дата
Msg-id CALDgxVuGNgdgEWdZDJeMB2aCXQ-=v8uiH6Yu40Mf8CozSNWNDA@mail.gmail.com
обсуждение исходный текст
Ответ на PgAdmin on Windows - UTF8 and WIN1252  (Baptiste GONOD <baptiste.gonod@gmail.com>)
Список pgadmin-support
Дерево обсуждения
Please do not top post. If you're using gmail's new reply interface, click on the "..." to reply inline.

On Tue, Dec 18, 2012 at 12:28 PM, Baptiste GONOD <baptiste.gonod@gmail.com> wrote:
Can you just create a database UTF8 and say me the psql -l return ? To see if you have windows.1252 on collate.

I wouldn't have that because my server is linux so my collation is en_US.UTF8.  I just tested on a French Windows server and the collation is "French, France"
 
More, if you have an application UTF8, test to insert data (with char as "é € à"...) then open pgadmin to consult them.
For me : "é à  €" give "é à  €". utf8 is encoded in 1252. You can replicate that with notepadd++ typing "é à  €", convert to utf8, then encoded in ANSI (or 1252 the same things).

This works as desired for me.

В списке pgadmin-support по дате отправления:

Предыдущее
От: Vik Reykja
Дата:
Сообщение: Re: PgAdmin on Windows - UTF8 and WIN1252
Следующее
От: Baptiste GONOD
Дата:
Сообщение: Re: PgAdmin on Windows - UTF8 and WIN1252