From: | Stuart Bishop <stuart(at)stuartbishop(dot)net> |
---|---|
To: | Harry Mantheakis <harry(at)mantheakis(dot)freeserve(dot)co(dot)uk> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Japanese words not distinguished |
Date: | 2005-07-14 04:03:13 |
Message-ID: | 42D5E401.10002@stuartbishop.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Harry Mantheakis wrote:
>>Correct. The lesson is, never use locale support for Asian languages
>>and multibyte encodings including UTF-8.
>
>
> Thank you for your reply - much appreciated.
>
> I'm now concerned if and how this will affect ORDER BY query results (and
> other functions) with respect to Latin-1 names and words.
>
> I think I'll have to suck it and see, and then post my results - but that
> won't be until after this next week-end.
C locale and en_* locales give different ordering (at least under Linux).
The en_* ordering is case insensitive, and the C locale ordering is case
sensitive because it is simply comparing the ASCII codes.
--
Stuart Bishop <stuart(at)stuartbishop(dot)net>
http://www.stuartbishop.net/
From | Date | Subject | |
---|---|---|---|
Next Message | Bob | 2005-07-14 04:18:04 | Re: Transparent encryption in PostgreSQL? |
Previous Message | Alvaro Herrera | 2005-07-14 02:58:22 | Re: Errors building older versions of PostgreSQL |