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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
