From derby-dev-return-8115-apmail-db-derby-dev-archive=db.apache.org@db.apache.org Fri Sep 02 20:40:17 2005 Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 70631 invoked from network); 2 Sep 2005 20:40:16 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 2 Sep 2005 20:40:16 -0000 Received: (qmail 61544 invoked by uid 500); 2 Sep 2005 20:40:15 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 61518 invoked by uid 500); 2 Sep 2005 20:40:15 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Development" Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 61505 invoked by uid 99); 2 Sep 2005 20:40:15 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 Sep 2005 13:40:15 -0700 X-ASF-Spam-Status: No, hits=2.6 required=10.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,DNS_FROM_RFC_WHOIS,SPF_HELO_FAIL X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [32.97.182.145] (HELO e5.ny.us.ibm.com) (32.97.182.145) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 Sep 2005 13:40:29 -0700 Received: from d01relay04.pok.ibm.com (d01relay04.pok.ibm.com [9.56.227.236]) by e5.ny.us.ibm.com (8.12.11/8.12.11) with ESMTP id j82KeClP001943 for ; Fri, 2 Sep 2005 16:40:12 -0400 Received: from d01av03.pok.ibm.com (d01av03.pok.ibm.com [9.56.224.217]) by d01relay04.pok.ibm.com (8.12.10/NCO/VERS6.7) with ESMTP id j82KeCdm097886 for ; Fri, 2 Sep 2005 16:40:12 -0400 Received: from d01av03.pok.ibm.com (loopback [127.0.0.1]) by d01av03.pok.ibm.com (8.12.11/8.13.3) with ESMTP id j82KeBA4017638 for ; Fri, 2 Sep 2005 16:40:11 -0400 Received: from [127.0.0.1] (sig-9-48-110-134.mts.ibm.com [9.48.110.134]) by d01av03.pok.ibm.com (8.12.11/8.12.11) with ESMTP id j82KeAYH017590 for ; Fri, 2 Sep 2005 16:40:11 -0400 Message-ID: <4318B8A9.8030405@sbcglobal.net> Date: Fri, 02 Sep 2005 13:40:09 -0700 From: Mike Matrigali Reply-To: mikem_app@sbcglobal.net User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Development Subject: Re: [jira] Created: (DERBY-554) ORDER By clause doesn't work with national strings References: <686299093.1125671191318.JavaMail.jira@ajax.apache.org> In-Reply-To: <686299093.1125671191318.JavaMail.jira@ajax.apache.org> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N I believe DERBY-533 would address this issue. Libor Krzyzanek (JIRA) wrote: > ORDER By clause doesn't work with national strings > -------------------------------------------------- > > Key: DERBY-554 > URL: http://issues.apache.org/jira/browse/DERBY-554 > Project: Derby > Type: Improvement > Components: JDBC > Versions: 10.1.1.0 > Environment: Win XP, JDK 1.5 > Reporter: Libor Krzyzanek > > > ORDER By clause doesn't work with national strings. When sort column with strings with national chracters (Czech = cs_CZ locale) , it doesn't sort properly (special characters is on the end of the alphabet but should not be). > > How to resolve the problem: > For national ordering just use java.text.Collator to compare strings. > > > > Sysinfo: > ------------------ Java Information ------------------ > Java Version: 1.5.0_04 > Java Vendor: Sun Microsystems Inc. > Java home: C:\Program Files\Java\jre1.5.0_04 > Java classpath: derby.jar;derbytools.jar > OS name: Windows XP > OS architecture: x86 > OS version: 5.1 > Java user dir: c:\develop\jars\db-derby-10.1.1.0-bin\lib > java.specification.name: Java Platform API Specification > java.specification.version: 1.5 > --------- Derby Information -------- > JRE - JDBC: J2SE 5.0 - JDBC 3.0 > [C:\develop\jars\db-derby-10.1.1.0-bin\lib\derby.jar] 10.1.1.0 - (208786) > [C:\develop\jars\db-derby-10.1.1.0-bin\lib\derbytools.jar] 10.1.1.0 - (208786) > ------------------------------------------------------ > ----------------- Locale Information ----------------- > ------------------------------------------------------ >