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@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
