Re: PgAdmin on Windows - UTF8 and WIN1252

Guillaume, can you provide any input here please? I only have English
systems to hand, so can't even properly test this.

On Fri, Dec 14, 2012 at 11:12 AM, Baptiste GONOD
<baptiste(dot)gonod(at)gmail(dot)com> wrote:
> < 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
>
>

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company