Re: PgAdmin on Windows - UTF8 and WIN1252

From: Vik Reykja <vikreykja(at)gmail(dot)com>
To: Baptiste GONOD <baptiste(dot)gonod(at)gmail(dot)com>
Cc: Guillaume Lelarge <guillaume(at)lelarge(dot)info>, Dave Page <dpage(at)pgadmin(dot)org>, pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: PgAdmin on Windows - UTF8 and WIN1252
Date: 2012-12-18 11:39:20
Message-ID: CALDgxVuGNgdgEWdZDJeMB2aCXQ-=v8uiH6Yu40Mf8CozSNWNDA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)gonod(at)gmail(dot)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.

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message prameej E 2012-12-19 08:39:19 DATA TRANSFER SPEED
Previous Message Baptiste GONOD 2012-12-18 11:28:40 Re: PgAdmin on Windows - UTF8 and WIN1252