createdb - problem with encodings
| От | Bartłomiej Romański |
|---|---|
| Тема | createdb - problem with encodings |
| Дата | |
| Msg-id | dda42a2e0908171132x3bff71daqa29fba9088452b5a@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: createdb - problem with encodings
|
| Список | 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 по дате отправления: