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@xxxxxxxxxxxxxxxx> http://www.stuartbishop.net/
Attachment:
signature.asc
Description: OpenPGP digital signature
