Re: server/db encoding (mix) issues

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: server/db encoding (mix) issues
Дата
Msg-id 48C4F322.1050905@gmx.net
обсуждение исходный текст
Ответ на Re: server/db encoding (mix) issues  (Jan-Peter.Seifert@gmx.de)
Список pgsql-admin
Jan-Peter.Seifert@gmx.de wrote:
> Well - I did setup two instances of 8.3.3 on an Ubuntu 7.10 system last week - both under a different user account. I
setthe locale for each account in the .bashrcs ("export LANG=de_DE" and "export LANG=de_DE.UTF-8" respectively). After
thatI ran initdb ("initdb --encoding='LATIN1' -W -A md5 -D $PGDATA" and "initdb --encoding='UTF8' -W -A md5 -D
$PGDATA"(?)).I'm not sure whether I specified the server encoding for the UTF8-instance though. Did I make something
wrong?

Not really, but I suggest you forget about the environment settings and
forget about the --encoding option and just use the --locale option of
initdb to set the locale settings.

> However, when I try to create an UTF-8 db in the LATIN1 server or an LATIN1 db in the UTF-8 server I get the error
thatthe db encoding does not match the server locale and that the LC_TYPE-Locale requires the encoding of the server.
Beforethat I thought it just fails because there is no locale with the name LATIN1 in windows. Are those additional
encodingchecks in v8.3.3 or had they been put in place with v8.3.1 already?  

They have existed since 8.3.0.


В списке pgsql-admin по дате отправления:

Предыдущее
От: Jan-Peter.Seifert@gmx.de
Дата:
Сообщение: Re: server/db encoding (mix) issues
Следующее
От: Jan-Peter.Seifert@gmx.de
Дата:
Сообщение: Re: pg_dump etc. versions