From: | Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | UTF-8 collation on Windows? |
Date: | 2014-02-19 14:41:51 |
Message-ID: | CALSLE1ORkk10pMuiyXLCZkFPx_v1+VnxK_B8hrX1GweNWRTSYw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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...
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Kane | 2014-02-19 14:46:59 | Possible to improve optimisation / index usage based on domain properties of a function |
Previous Message | Pavel Stehule | 2014-02-19 14:40:20 | Re: why VARIADIC functions executed on array input? |