< 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 <dp...@pgadmin.org> > On Fri, Dec 14, 2012 at 10:46 AM, Baptiste GONOD > <baptiste.go...@gmail.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 >
