Re: PgAdmin on Windows - UTF8 and WIN1252

< You said your database was UTF-8. So where does WIN1252 come into this?
If the database is in UTF-8, pgAdmin uses UTF-8 internally, there should
never be any WIN1252 involved at all.

>
when I install postgreSQL or create my cluster by command line, my database
is encoded in utf8, but collation and type of char are French_France.1252.
And if I try something like :

initdb --locale French_France.UTF8 -D "..."
initdb --encoding utf8 --locale French_France -D "..."
initdb --encoding utf8 --locale utf8 -D "..."
...
or something else about utf8, system says that the locale isn't know and
set default to french_france.1252.

And when I look data with pgadmin, there's a conversion utf8 to WIN1252 of
my data (on display, not in stored).

At the install of postgreSQL, it ask the locales. Do I must choose another
choice of French ?

2012/12/14 Dave Page <dpage(at)pgadmin(dot)org>

> On Fri, Dec 14, 2012 at 10:46 AM, Baptiste GONOD
> <baptiste(dot)gonod(at)gmail(dot)com> wrote:
> > Ok that's a front-end. My problem isn't with my website.. he's work fine
> in
> > utf8 with postgreSQL in utf8 - tested with pg_connect or odbc connection.
>
> OK.
>
> > PgAdmin is a front-end too, not ?! And it's pgadmin that doesn't display
> > data in utf8. All is encoded in WIN1252 whereas all settings are
> > utf8/unicode in all options.
>
> You said your database was UTF-8. So where does WIN1252 come into
> this? If the database is in UTF-8, pgAdmin uses UTF-8 internally,
> there should never be any WIN1252 involved at all.
>
> > More, phppgadmin has the same problem. So we could conclude that my
> database
> > isn't in utf8, but postgreSQL say no.
>
> If phpPgAdmin has the same issue, than that also implies there's
> something getting messed up in your front end, that causing data to be
> stored differently than you expect. Both pgAdmin and phpPgAdmin have
> been used for 10+ years by hundreds of thousands of people with UTF-8
> data.
>
> > So, pgadmin and phpadmin use the same device to collect data ? And this
> is
> > the way which wrong ?
>
> The only common thing between them is libpq - which is also used by
> psql, pg_dump, pg_restore etc. It's even more tried and tested than
> the admin tools, as every single PostgreSQL installation there is
> relies on it.
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>