Re: UTF-8 collation on Windows? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: UTF-8 collation on Windows?
Date
Msg-id 53051002.2040007@aklaver.com
Whole thread Raw
In response to Re: UTF-8 collation on Windows?  (Dev Kumkar <devdas.kumkar@gmail.com>)
Responses Re: UTF-8 collation on Windows?
List pgsql-general
On 02/19/2014 12:03 PM, Dev Kumkar wrote:
> On Thu, Feb 20, 2014 at 1:19 AM, Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:
>
>     So what is the exact command you are using?
>
>
> createdb -U postgres -E utf8 -l american_usa <DBNAME>
> Above command fails to create utf-8 LC_COLLATE.

What does it set LC_CTYPE to?

So what happens if you do?:

createdb -U postgres -E utf8 -l american_usa.65001 <DBNAME>

or

createdb -U postgres -E utf8 --lc-ctype=american_usa
--lc-collate=american_usa <DBNAME>

>
> Regards...



pgsql-general by date:

Previous
From: Dev Kumkar
Date:
Subject: Re: UTF-8 collation on Windows?
Next
From: Dev Kumkar
Date:
Subject: Re: UTF-8 collation on Windows?