Re: UTF-8 collation on Windows?

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com>
Cc: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: UTF-8 collation on Windows?
Date: 2014-02-20 20:32:50
Message-ID: 53066672.3090407@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 02/20/2014 12:27 PM, Dev Kumkar wrote:
> On Fri, Feb 21, 2014 at 1:26 AM, Adrian Klaver
> <adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>
> Well I dug out a Windows machine and tried to get what you wanted,
> to no avail. As far as I know there is no UTF8 collation, it is an
> encoding. What you want if I am following, is the en_US locale (or
> equivalent for another language) on Windows. Anything I tried
> resolved back to a Windows code page. So the answer from my tests,
> is no you cannot match en_US on Windows.
>
>
> Thanks for taking time out and looking into it !
> Yes all the scenarios we tested didn't work for any of the utf8 code
> pages specified on MSDN or may be I don't know the correct
> representation of "language_territory.code".

It seems to be more basic then that. Microsoft has its own locale
mechanism and you will always be redirected back to it.

>
> Regards...

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Santo Campione 2014-02-20 20:45:09 Will Postgres work with Oracle Forms 6i?
Previous Message Adrian Klaver 2014-02-20 20:29:30 Re: UTF-8 collation on Windows?