Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 45501 invoked from network); 20 Sep 2004 09:52:48 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 20 Sep 2004 09:52:48 -0000 Received: (qmail 33775 invoked by uid 500); 20 Sep 2004 09:52:47 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 33749 invoked by uid 500); 20 Sep 2004 09:52:46 -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 33734 invoked by uid 99); 20 Sep 2004 09:52:46 -0000 X-ASF-Spam-Status: No, hits=1.6 required=10.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,NO_REAL_NAME,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of wegorkie@interia.pl designates 217.74.65.138 as permitted sender) Received: from [217.74.65.138] (HELO eri.interia.pl) (217.74.65.138) by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 20 Sep 2004 02:52:46 -0700 Received: from poczta.interia.pl (f18.poczta.interia.pl [10.217.2.18]) by eri.interia.pl (Postfix) with ESMTP id 933D4267B7 for ; Mon, 20 Sep 2004 11:52:35 +0200 (CEST) Received: by poczta.interia.pl (Postfix, from userid 502) id A487C3D86AE; Mon, 20 Sep 2004 11:52:43 +0200 (CEST) Date: 20 Sep 2004 11:52:43 +0200 From: wegorkie@interia.pl Subject: Localizing ORDER BY clause To: derby-dev@db.apache.org MIME-Version: 1.0 Content-Type: TEXT/plain; CHARSET=ISO-8859-2 X-EMID: e6740acc X-ORIGINATE-IP: 194.106.192.5 Organization: Poczta INTERIA.PL >>> http://poczta.interia.pl/ Message-Id: <20040920095243.A487C3D86AE@poczta.interia.pl> X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Hello, I need to localize collation order in ORDER BY clauses to Polish locale. Is it possible in Derby? When I sort data from table it puts Polish diacritics at the end of the sorted list. It should put it according to Polish alphabet. I read that Derby does not support Polish territory (pl_PL). Does territory support include collation ordering? Is it easy to add pl_PL support to Derby, I mean for example by adding some resource files? Thanks in advance, Maciek Wegorkiewicz