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