Re: logfile character encoding

Am 17.08.2014 16:49, schrieb Adrian Klaver:

> Here is a blog
> that seems to address your issue somewhat:
>
> http://www.g-loaded.eu/2011/02/27/locale-windows/

This seems somewhat confused. But it made me playing with initdb, which
I did not try before.

I got:
> >initdb.exe --locale=american_usa --encoding=UTF-8 --pgdata C:/Daten/pgdata2/
> The database cluster will be initialized with locale "English_United States.1252".
> The default text search configuration will be set to "english".
So also Blogger George will have Windows-1252 messages, if ever an
english message from Postmaster will contain Non-ASCII.

> >initdb.exe --locale=English --encoding=UTF-8 --pgdata C:/Daten/pgdata2/
the same

> >initdb.exe --locale=English --pgdata C:/Daten/pgdata2/
> The database cluster will be initialized with locale "English_United States.1252".
> The default database encoding has accordingly been set to "WIN1252".
> The default text search configuration will be set to "english".
Additional message when I leave out the encoding parameter.

> >initdb.exe --pgdata C:/Daten/pgdata2/
> The database cluster will be initialized with locale "German_Germany.1252".
> The default database encoding has accordingly been set to "WIN1252".
> The default text search configuration will be set to "german".
using default values

> >initdb.exe --locale=German_Germany.874 --pgdata C:/Daten/pgdata2/
> The database cluster will be initialized with locale "German_Germany.874".
> The default database encoding has accordingly been set to "WIN874".
> The default text search configuration will be set to "german".
I can haz Thai Codepage =:-}

> >initdb.exe --locale=German_Germany.UTF-8 --pgdata C:/Daten/pgdata2/
> initdb: invalid locale name "German_Germany.UTF-8"
> The database cluster will be initialized with locale "German_Germany.1252".
> The default database encoding has accordingly been set to "WIN1252".
> The default text search configuration will be set to "german".
but no UTF-8; same for ".UTF8" or ".65001"

> >initdb.exe --encoding=UTF-8 --pgdata C:/Daten/pgdata2/
> The database cluster will be initialized with locale "German_Germany.1252".
> The default text search configuration will be set to "german".
So this probably is the configuration I started with.

Thanks,
Redoute