Re: PgAdmin on Windows - UTF8 and WIN1252 - Mailing list pgadmin-support

< You said your database was UTF-8. So where does WIN1252 come into this? If the database is in UTF-8, pgAdmin uses
UTF-8internally, there should never be any WIN1252 involved at all.<br /><br />><br />when I install postgreSQL or
createmy 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 :<br /><br />initdb --locale French_France.UTF8 -D "..."<br />initdb
--encodingutf8 --locale French_France -D "..."<br />initdb --encoding utf8 --locale utf8 -D "..."<br />...<br />or
somethingelse about utf8, system says that the locale isn't know and set default to french_france.1252.<br /><br />And
whenI look data with pgadmin, there's a conversion utf8 to WIN1252 of my data (on display, not in stored).<br /><br
/>Atthe install of postgreSQL, it ask the locales. Do I must choose another choice of French ?<br /><div
class="gmail_extra"><br/><br /><div class="gmail_quote">2012/12/14 Dave Page <span dir="ltr"><<a
href="mailto:dpage@pgadmin.org"target="_blank">dpage@pgadmin.org</a>></span><br /><blockquote class="gmail_quote"
style="margin:00 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">On Fri, Dec 14, 2012 at 10:46 AM,
BaptisteGONOD<br /> <<a href="mailto:baptiste.gonod@gmail.com">baptiste.gonod@gmail.com</a>> wrote:<br /> > Ok
that'sa front-end. My problem isn't with my website.. he's work fine in<br /> > utf8 with postgreSQL in utf8 -
testedwith pg_connect or odbc connection.<br /><br /></div>OK.<br /><div class="im"><br /> > PgAdmin is a front-end
too,not ?! And it's pgadmin that doesn't display<br /> > data in utf8. All is encoded in WIN1252 whereas all
settingsare<br /> > utf8/unicode in all options.<br /><br /></div>You said your database was UTF-8. So where does
WIN1252come into<br /> this? If the database is in UTF-8, pgAdmin uses UTF-8 internally,<br /> there should never be
anyWIN1252 involved at all.<br /><div class="im"><br /> > More, phppgadmin has the same problem. So we could
concludethat my database<br /> > isn't in utf8, but postgreSQL say no.<br /><br /></div>If phpPgAdmin has the same
issue,than that also implies there's<br /> something getting messed up in your front end, that causing data to be<br />
storeddifferently than you expect. Both pgAdmin and phpPgAdmin have<br /> been used for 10+ years by hundreds of
thousandsof people with UTF-8<br /> data.<br /><div class="im"><br /> > So, pgadmin and phpadmin use the same device
tocollect data ? And this is<br /> > the way which wrong ?<br /><br /></div>The only common thing between them is
libpq- which is also used by<br /> psql, pg_dump, pg_restore etc. It's even more tried and tested than<br /> the admin
tools,as every single PostgreSQL installation there is<br /> relies on it.<br /><div class="HOEnZb"><div class="h5"><br
/>--<br /> Dave Page<br /> Blog: <a href="http://pgsnake.blogspot.com"
target="_blank">http://pgsnake.blogspot.com</a><br/> Twitter: @pgsnake<br /><br /> EnterpriseDB UK: <a
href="http://www.enterprisedb.com"target="_blank">http://www.enterprisedb.com</a><br /> The Enterprise PostgreSQL
Company<br/></div></div></blockquote></div><br /></div>