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