Postgres Pro
Downloads
Home   >   mailing lists

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

From Dev Kumkar
Subject Re: UTF-8 collation on Windows?
Date
Msg-id CALSLE1OWsbTM7Xbz=JrKm_ka9R3PyUntbW=O6CQPEBdsgEp4Rw@mail.gmail.com
Whole thread Raw
In response to Re: UTF-8 collation on Windows?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: UTF-8 collation on Windows?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: UTF-8 collation on Windows?  ("Daniel Verite" <daniel@manitou-mail.org>)
List pgsql-general
Tree view
On Thu, Feb 20, 2014 at 1:41 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
What does it set LC_CTYPE to?

So what happens if you do?:

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

createdb: database creation failed: ERROR:  invalid locale name: "american_usa.65001"


or

createdb -U postgres -E utf8 --lc-ctype=american_usa --lc-collate=american_usa <DBNAME>
Succeeds but as replied earlier it creates database with LC_COLLATE = 'English_United States.1252' which corresponds to Latin1.

Regards...

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: UTF-8 collation on Windows?
Next
From: Adrian Klaver
Date:
Subject: Re: UTF-8 collation on Windows?