How to find correct locale name for CREATE DATABASE
| От | Andrus |
|---|---|
| Тема | How to find correct locale name for CREATE DATABASE |
| Дата | |
| Msg-id | 8D35B2E43A6B4949864C987F088BC3B4@andrusnotebook обсуждение исходный текст |
| Ответы |
Re: How to find correct locale name for CREATE DATABASE
|
| Список | pgsql-general |
I tried in Debian ("PostgreSQL 9.0.1 on x86_64-pc-linux-gnu, compiled by
GCC gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 64-bit") :
1. CREATE DATABASE "mydb" WITH TEMPLATE=template0
LC_COLLATE='Estonian_Estonia.1257' LC_CTYPE='Estonian_Estonia.1257'
OWNER="mydb_owner" ENCODING='UNICODE'
2. CREATE DATABASE "mydb" WITH TEMPLATE=template0 LC_COLLATE='et_EE.UTF-8'
LC_CTYPE='et_EE.UTF-8' OWNER="mydb_owner" ENCODING='UNICODE'
3. 2. CREATE DATABASE "mydb" WITH TEMPLATE=template0
LC_COLLATE='et_EE.UTF8'
LC_CTYPE='et_EE.UTF8' OWNER="mydb_owner" ENCODING='UNICODE'
in all cases same error
invalid locale name
occurs.
Questions:
1. How to find correct locale name for Estonian in Debian Linux ?
In Windows case (1) works.
2. How to create portable CREATE DATABASE command for estonian locale which
works in all operating systems?
3. Or how to detect OS from PostgreSql server and select correct Estonian
locale ?
Andrus.
В списке pgsql-general по дате отправления: