Re: [GENERAL] utf-8 and cultural sensitive sorting

2005-07-12 Thread Tatsuo Ishii
> It depends what language you want to sort. Lots of languages do not > have a sort alphabet. For example, Japanese. It can be quite > difficult to sort unusual languages like this. I am not aware of any > standard technique for sorting Japanese text other than keeping an > arbitrarily sort

Re: [GENERAL] utf-8 and cultural sensitive sorting

2005-07-12 Thread Alex Stapleton
It depends what language you want to sort. Lots of languages do not have a sort alphabet. For example, Japanese. It can be quite difficult to sort unusual languages like this. I am not aware of any standard technique for sorting Japanese text other than keeping an arbitrarily sorted diction

Re: [GENERAL] utf-8 and cultural sensitive sorting

2005-07-12 Thread Richard Huxton
[EMAIL PROTECTED] wrote: Our product will be storing its character data in utf-8 format (unicode encoding). What is the best way to achive cultural sensitive sorting using the utf-8 data? See below. Is it possible have the locale apply to a connection? A locale applies to a whole databas