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

From Adrian Klaver
Subject Re: UTF-8 collation on Windows?
Date
Msg-id 53050AC1.5090207@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 11:42 AM, Dev Kumkar wrote:
> On Wed, Feb 19, 2014 at 10:16 PM, Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:
>
>     I found the below that might help. I do not use Windows much any
>     more so I do not have a machine handy to confirm.
>
>     http://www.g-loaded.eu/2011/02/27/locale-windows/
>
>
> Thanks for the pointer. "*american_usa*" works however it sets the
> LC_COLLATE to 'English_United States.1252' which is basically "ANSI
> Latin 1" and is not utf8. The third parameter as the link says is
> codeset - "language_territory.codeset".

So what is the exact command you are using?

>
> Here is the list of all codesets
> http://msdn.microsoft.com/en-us/library/dd317756%28VS.85%29.aspx but
> still no success.
>
> One of the link says codepage 65001 and utf-8 is same -
> http://stackoverflow.com/questions/1629437/is-codepage-65001-and-utf-8-the-same-thing.
>
> Am not able to find windows codeset equivalent of utf-8 and set it as
> LC_COLLATE while creating database.
>
> Has anyone set the LC_COLLATE as utf-8 on windows?
>
> Regards...



pgsql-general by date:

Previous
From: Dev Kumkar
Date:
Subject: Re: UTF-8 collation on Windows?
Next
From: Dev Kumkar
Date:
Subject: Re: Timezone information