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@stuartbishop.net>
http://www.stuartbishop.net/