From: | Redoute <redoute(at)tortenboxer(dot)de> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: logfile character encoding |
Date: | 2014-08-17 22:09:11 |
Message-ID: | 53F12807.8080409@tortenboxer.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Redoute | 2014-08-17 22:32:44 | Re: logfile character encoding |
Previous Message | Tom Lane | 2014-08-17 15:17:19 | Re: logfile character encoding |