Re: UTF-8 collation on Windows?

[Dev Kumkar <devdas.kumkar@xxxxxxxxx>]

On Thu, Feb 20, 2014 at 1:41 AM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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...