< 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 ?
On Fri, Dec 14, 2012 at 10:46 AM, Baptiste GONOD <baptiste.gonod@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.
