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