Re: UTF-8 collation on Windows?

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: UTF-8 collation on Windows?
Date: 2014-02-19 20:11:46
Message-ID: 53051002.2040007@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 02/19/2014 12:03 PM, Dev Kumkar wrote:
> On Thu, Feb 20, 2014 at 1:19 AM, Adrian Klaver
> <adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)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...

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dev Kumkar 2014-02-19 20:16:01 Re: UTF-8 collation on Windows?
Previous Message Dev Kumkar 2014-02-19 20:03:33 Re: UTF-8 collation on Windows?