Postgres Pro
Downloads
Home   >   mailing lists

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

From Dev Kumkar
Subject Re: UTF-8 collation on Windows?
Date
Msg-id CALSLE1MwOZcL8RMe9etc7CH1NkRUYrOi2v3W1qsPnL1=-4pwQA@mail.gmail.com
Whole thread Raw
In response to Re: UTF-8 collation on Windows?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: UTF-8 collation on Windows?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
On Wed, Feb 19, 2014 at 10:16 PM, Adrian Klaver <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".

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: Rahul Saha
Date:
Subject: Re: configuration error
Next
From: Adrian Klaver
Date:
Subject: Re: UTF-8 collation on Windows?