Re: UTF-8 collation on Windows?

On 02/19/2014 06:41 AM, Dev Kumkar wrote:
> Am really going no where with this after so many searching over net or
> am missing some basic things, not sure!
>
> What is the equivalent for "en_US.UTF-8" collation in case of windows?
>
> In Linux am creating database with following options, as follows:
> -E utf8 -l en_US.UTF-8 -T template0
>
> This creates utf8 encoding and also the collation is set as en_US.UTF-8.
>
> in case of windows utf8 encoding parameter works but not sure abou the
> equivalent for en_US.UTF-8 collation.
> Default database gets created with 'English_United States.1252' collation.
>
> As a result the sorting is not same in case of windows and linux database.
>
> Any suggestions/ pointers here?

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/

>
> Regards...
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com