Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 63030 invoked from network); 29 Apr 2008 18:25:38 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 29 Apr 2008 18:25:38 -0000 Received: (qmail 37365 invoked by uid 500); 29 Apr 2008 18:25:39 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 37330 invoked by uid 500); 29 Apr 2008 18:25:39 -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: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 37285 invoked by uid 99); 29 Apr 2008 18:25:39 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 29 Apr 2008 11:25:39 -0700 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 29 Apr 2008 18:25:02 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id DB7F9234C113 for ; Tue, 29 Apr 2008 11:21:56 -0700 (PDT) Message-ID: <48087340.1209493316898.JavaMail.jira@brutus> Date: Tue, 29 Apr 2008 11:21:56 -0700 (PDT) From: "Mamta A. Satoor (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Closed: (DERBY-1478) Add built in language based ordering and like processing to Derby In-Reply-To: <11092987.1152139470894.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-1478?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mamta A. Satoor closed DERBY-1478. ---------------------------------- > Add built in language based ordering and like processing to Derby > ----------------------------------------------------------------- > > Key: DERBY-1478 > URL: https://issues.apache.org/jira/browse/DERBY-1478 > Project: Derby > Issue Type: Improvement > Components: SQL > Affects Versions: 10.1.2.1 > Reporter: Kathey Marsden > Assignee: Mamta A. Satoor > Attachments: DERBY-1478_FunctionalSpecV1.html, DERBY-1478_FunctionalSpecV2.html, DERBY-1478_FunctionalSpecV3.html, DERBY-1478_FunctionalSpecV4.html, DERBY-1478_FunctionalSpecV5.html > > > It would be good for Derby to have built in Language based ordering based on locale specific Collator. > Language based ordering is an important feature for international deployment. DERBY-533 offers one implementation option for this but according to the discussion in that issue National Character Types carry a fair amount of baggage with them especially in the form of concerns about conversion to and from datetime and number types. Rick mentioned SQL language for collations as an option for language based ordering. There may be other options too, but I thought it worthwhile to add an issue for the high level functional concern, so the best choice can be made for implementation without assuming that National Character Types is the only solution. > For possible 10.1 workaround and examples see: > http://wiki.apache.org/db-derby/LanguageBasedOrdering -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.