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

On 02/19/2014 01:09 PM, Dev Kumkar wrote:
> On Thu, Feb 20, 2014 at 2:24 AM, Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:
>
>     Alright last shot:)
>
>     Taking hint from here:
>
>     http://msdn.microsoft.com/en-__us/library/x99tb11d.aspx
>     <http://msdn.microsoft.com/en-us/library/x99tb11d.aspx>
>
>     try:
>
>     createdb -U postgres -E utf8 -l en-US <DBNAME>
>
>     If that does not work, not sure where to go.
>
>
> This won't work on Windows. Note that en-US collation name is specific
> to linux and in case of Windows these names are different which is where
> am facing issues to find the exact code page which corresponds to utf8.

Have you tried it?

Note that the locale name is different then the one Linux.

On Linux it is en_US.

What I suggested is en-US.