Re: initdb - encoding question

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: initdb - encoding question
Дата
Msg-id 200712051111.54344.peter_e@gmx.net
обсуждение исходный текст
Ответ на initdb - encoding question  ("Josh Harrison" <joshques@gmail.com>)
Список pgsql-general
Am Montag, 3. Dezember 2007 schrieb Josh Harrison:
> initdb -E UTF8 -D /export/home/josh/postgres8.3/pgsql/data

> The database cluster will be initialized with locales
>   COLLATE:  en_CA.ISO8859-1
>   CTYPE:    en_CA.ISO8859-1
>   MESSAGES: C
>   MONETARY: en_CA.ISO8859-1
>   NUMERIC:  en_CA.ISO8859-1
>   TIME:     C
> initdb: encoding mismatch
> The encoding you selected (UTF8) and the encoding that the
> selected locale uses (LATIN1) do not match.  This would lead to
> misbehavior in various character string processing functions.
> Rerun initdb and either do not specify an encoding explicitly,
> or choose a matching combination.
>
> Why do I get this error?

It's an encoding mismatch.  The encoding you selected (UTF8) and the encoding
that the selected locale uses (LATIN1) do not match.  This would lead to
misbehavior in various character string processing functions.

> How can I solve this?

Rerun initdb and either do not specify an encoding explicitly, or choose a
matching combination.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

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

Предыдущее
От: "Marko Kreen"
Дата:
Сообщение: Re: pgcrypto functions fail for asymmetric encryption/decryption
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: initdb - encoding question