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.klaver@aklaver.com
