Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 522A61337B7E for ; Tue, 30 Nov 2010 15:31:13 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 24985-08 for ; Tue, 30 Nov 2010 19:31:06 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mailout-de.gmx.net [213.165.64.23]) by mail.postgresql.org (Postfix) with SMTP id A08C31337B69 for ; Tue, 30 Nov 2010 15:31:05 -0400 (AST) Received: (qmail invoked by alias); 30 Nov 2010 19:31:04 -0000 Received: from a88-115-218-165.elisa-laajakaista.fi (EHLO [10.0.0.101]) [88.115.218.165] by mail.gmx.net (mp011) with SMTP; 30 Nov 2010 20:31:04 +0100 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX18EffAuN4cEwTYhU30LvnTMaqsK5Lix55LTxUNOcg GHRoLfll3qr5Hz Subject: Re: How strings are sorted by LC_COLLATE specifically? From: Peter Eisentraut To: Chang Chao Cc: pgsql-sql@postgresql.org In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Date: Tue, 30 Nov 2010 21:31:02 +0200 Message-ID: <1291145462.13957.10.camel@vanquo.pezone.net> Mime-Version: 1.0 X-Mailer: Evolution 2.30.3 Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/96 X-Sequence-Number: 34834 On tor, 2010-11-25 at 14:42 +0900, Chang Chao wrote: > 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. > because some of the sort logic is here. The actual string comparison is done by the strcoll() function in the operating system's C library.