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

From Adrian Klaver
Subject Re: UTF-8 collation on Windows?
Date
Msg-id 53051ED4.4010904@aklaver.com
Whole thread Raw
In response to Re: UTF-8 collation on Windows?  (Dev Kumkar <devdas.kumkar@gmail.com>)
Responses Re: UTF-8 collation on Windows?
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.




pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Timezone information
Next
From: Dev Kumkar
Date:
Subject: Re: Timezone information