createdb - problem with encodings

Поиск
Список
Период
Сортировка
От Bartłomiej Romański
Тема createdb - problem with encodings
Дата
Msg-id dda42a2e0908171132x3bff71daqa29fba9088452b5a@mail.gmail.com
обсуждение исходный текст
Ответы Re: createdb - problem with encodings  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-admin
Hi all,

I've got a strange problem with creating a new database:

br@ovh1:~$ createdb -E utf8 test
createdb: database creation failed: ERROR:  encoding UTF8 does not
match server's locale en_US.utf8
DETAIL:  The server's LC_CTYPE setting requires encoding LATIN1.

I've got some databases with UTF8 encoding and I have no idea why I
cannot create a new one now...

br@ovh1:~$ psql -l
         List of databases
    Name     |  Owner   | Encoding
-------------+----------+----------
 xxxxxxxx    | br       | UTF8
 xxxxxxxxxx | br       | UTF8
 xxxxxxxxxx  | br       | UTF8
 postgres    | postgres | UTF8
 template0   | postgres | UTF8
 template1   | postgres | UTF8
(6 rows)

When I connect to any of them I can check my LC_CTYPE and my LC_COLLATE:

postgres=# show lc_ctype ;
  lc_ctype
------------
 en_US.utf8
(1 row)

postgres=# show lc_collate ;
 lc_collate
------------
 en_US.utf8
(1 row)

I can create a database with LATIN1 encoding. Why I cannot create a
new one with UTF8? Do you have any ideas?

I've read that doing initdb with correct locale may help. But what
should be the correct locale if not en_US.utf8??

Thank for any help,
Bartek

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

Предыдущее
От: OldManRiver
Дата:
Сообщение: Re: Just Forgot
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: createdb - problem with encodings