From: | Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: UTF-8 collation on Windows? |
Date: | 2014-02-19 19:42:15 |
Message-ID: | CALSLE1MwOZcL8RMe9etc7CH1NkRUYrOi2v3W1qsPnL1=-4pwQA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Feb 19, 2014 at 10:16 PM, Adrian Klaver
<adrian(dot)klaver(at)aklaver(dot)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...
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2014-02-19 19:49:21 | Re: UTF-8 collation on Windows? |
Previous Message | Rahul Saha | 2014-02-19 19:05:09 | Re: configuration error |