Postgres Pro
Downloads
Home   >   mailing lists

Re: PgAdmin on Windows - UTF8 and WIN1252 - Mailing list pgadmin-support

From Vik Reykja
Subject Re: PgAdmin on Windows - UTF8 and WIN1252
Date
Msg-id CALDgxVuGNgdgEWdZDJeMB2aCXQ-=v8uiH6Yu40Mf8CozSNWNDA@mail.gmail.com
Whole thread Raw
In response to PgAdmin on Windows - UTF8 and WIN1252  (Baptiste GONOD <baptiste.gonod@gmail.com>)
List pgadmin-support
Tree view
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 by date:

Previous
From: Vik Reykja
Date:
Subject: Re: PgAdmin on Windows - UTF8 and WIN1252
Next
From: Baptiste GONOD
Date:
Subject: Re: PgAdmin on Windows - UTF8 and WIN1252