Postgres Pro
Downloads
Home   >   mailing lists

Re: How to find correct locale name for CREATE DATABASE - Mailing list pgsql-general

From Thom Brown
Subject Re: How to find correct locale name for CREATE DATABASE
Date
Msg-id AANLkTik3Y6bT_8hF_xeO1DOwHQAXbUawWQketSd0pDLh@mail.gmail.com
Whole thread Raw
In response to How to find correct locale name for CREATE DATABASE  ("Andrus" <kobruleht2@hot.ee>)
Responses Re: How to find correct locale name for CREATE DATABASE  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-general
Tree view 
2010/11/30 Andrus <kobruleht2@hot.ee>:
> 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.

You can list available locales on your system with: locale -a

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: How to find correct locale name for CREATE DATABASE
Next
From: Jasen Betts
Date:
Subject: Re: Comparing first 3 numbers of a IPv4 address?