| From: | Guido Neitzer <guido(dot)neitzer(at)pharmaline(dot)de> |
|---|---|
| To: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Ordering and unicode |
| Date: | 2005-11-11 09:43:42 |
| Message-ID: | 65F51FD2-7135-4E31-8C18-10B120C8A6A8@pharmaline.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 11.11.2005, at 9:33 Uhr, Guido Neitzer wrote:
> Yes, as far as I know there is no other way of changing the locale
> settings. Hopefully you are on Linux! If you deploy on Mac OS X or
> *BSD it won't work even with a change.
I have to correct me: Hopefully you are not on Mac OS X. On Mac OS X,
locale support is not yet available for UTF-8, so you will not get
correct ordering. This is from a statement of an Apple engineer --
they have this on the to do list.
As the locale support in Mac OS X comes directly from BSD I assume,
it's not better there but I have tested this only on one BSD
plattform and looked through the provided locale files (in the given
cvs directories) for others where it seems similar.
This is not a problem of PostgreSQL, only a problem for PostgreSQL
when running on the "wrong" plattform.
cug
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lincoln Yeoh | 2005-11-11 09:45:28 | Re: PREPARE TRANSACTION and webapps |
| Previous Message | Andrus | 2005-11-11 09:31:37 | Re: Best way to use indexes for partial match at |