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?
Regards...