[pgadmin-support] PgAdmin on Windows - UTF8 and WIN1252

2012-12-14 Thread Baptiste GONOD
Hi, is it possible to have a database encoded utf8 and a correct display in pgAdmin on (Windows) ? All my attempts of setting had failed and display the data encoded Windows-1252 : - update client_encoding in .cong - install version 8.3 (choosing server and client encode) - install phpPgAdmin -

Re: [pgadmin-support] PgAdmin on Windows - UTF8 and WIN1252

2012-12-14 Thread Dave Page
On Fri, Dec 14, 2012 at 7:54 AM, Baptiste GONOD wrote: > Hi, > > is it possible to have a database encoded utf8 and a correct display in > pgAdmin on (Windows) ? Yes - people do it all the time, myself included. You don't need to do anything to make it work - just connect, pgAdmin will set the cl

Re: [pgadmin-support] PgAdmin on Windows - UTF8 and WIN1252

2012-12-14 Thread Dave Page
[Please keep replies on the mailing list] On Fri, Dec 14, 2012 at 10:08 AM, Baptiste GONOD wrote: > psql -l return that database is utf8 and show client_encoding too. > And I install postgre on two computers, with different versions. > > >>"your front-end app is messing up the encoding of what's

Re: [pgadmin-support] PgAdmin on Windows - UTF8 and WIN1252

2012-12-14 Thread Dave Page
On Fri, Dec 14, 2012 at 10:26 AM, Baptiste GONOD wrote: > < [Please keep replies on the mailing list] >> Someone give me pgadmin-support@postgresql.org so where do I must post ? >> Send to the same mail ? To pgadmin-support@postgresql.org. Just hit Reply All, so the list is CC'd. > < I'm talking

Re: [pgadmin-support] PgAdmin on Windows - UTF8 and WIN1252

2012-12-14 Thread Dave Page
On Fri, Dec 14, 2012 at 10:46 AM, Baptiste GONOD 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

Re: [pgadmin-support] PgAdmin on Windows - UTF8 and WIN1252

2012-12-14 Thread Baptiste GONOD
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. 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/unico

Re: [pgadmin-support] PgAdmin on Windows - UTF8 and WIN1252

2012-12-14 Thread Baptiste GONOD
< 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 a