Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 82669 invoked from network); 13 Dec 2006 18:27:45 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 13 Dec 2006 18:27:45 -0000 Received: (qmail 42030 invoked by uid 500); 13 Dec 2006 18:27:52 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 42002 invoked by uid 500); 13 Dec 2006 18:27:52 -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 41993 invoked by uid 99); 13 Dec 2006 18:27:51 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 13 Dec 2006 10:27:51 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 13 Dec 2006 10:27:43 -0800 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id B8EC571413D for ; Wed, 13 Dec 2006 10:27:22 -0800 (PST) Message-ID: <9824342.1166034442754.JavaMail.jira@brutus> Date: Wed, 13 Dec 2006 10:27:22 -0800 (PST) From: "Mamta A. Satoor (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Commented: (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 [ http://issues.apache.org/jira/browse/DERBY-1478?page=comments#action_12458222 ] Mamta A. Satoor commented on DERBY-1478: ---------------------------------------- While researching the net on internationalization and localization, I found an excellent tutorial by Sun at http://java.sun.com/docs/books/tutorial/i18n/index.html Anyone who wants to get familiarized with the concepts related to internationalization will benefit from this tutorial. > Add built in language based ordering and like processing to Derby > ----------------------------------------------------------------- > > Key: DERBY-1478 > URL: http://issues.apache.org/jira/browse/DERBY-1478 > Project: Derby > Issue Type: Improvement > Components: SQL > Affects Versions: 10.1.2.1 > Reporter: Kathey Marsden > Assigned To: Mamta A. Satoor > > 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. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira