Re: [SQL] How strings are sorted by LC_COLLATE specifically?

2010-12-01 Thread Chang Chao
Hi Peter. When I looked into the source(),came to know that strings are sorted like this. int result = strcoll(a, b); if (result == 0) { result = strcmp(a,b); } return result; On Wed, Dec 1, 2010 at 4:31 AM, Peter Eisentraut wrote: > On tor, 2010-11-25 at 14:42 +0900, Chang C

[SQL] How strings are sorted by LC_COLLATE specifically?

2010-11-24 Thread Chang Chao
Hello Dear All. How strings are sorted when LC_COLLATE = ja_JP.UTF-8. I tried to read the documention on that,but there are just a few words, like LC_COLLATE determines string sort order, Is there a specific reference about this? So I can implement an equivalent string sort function in JAVA. becau