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

From Dev Kumkar
Subject UTF-8 collation on Windows?
Date
Msg-id CALSLE1ORkk10pMuiyXLCZkFPx_v1+VnxK_B8hrX1GweNWRTSYw@mail.gmail.com
Whole thread Raw
Responses Re: UTF-8 collation on Windows?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Am really going no where with this after so many searching over net or am missing some basic things, not sure!

What is the equivalent for "en_US.UTF-8" collation in case of windows?

In Linux am creating database with following options, as follows:
-E utf8 -l en_US.UTF-8 -T template0

This creates utf8 encoding and also the collation is set as en_US.UTF-8.

in case of windows utf8 encoding parameter works but not sure abou the equivalent for en_US.UTF-8 collation.
Default database gets created with 'English_United States.1252' collation.

As a result the sorting is not same in case of windows and linux database.

Any suggestions/ pointers here?

Regards...



pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: why VARIADIC functions executed on array input?
Next
From: Tim Kane
Date:
Subject: Possible to improve optimisation / index usage based on domain properties of a function