Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Mon, 26 Aug 2013 20:11:51 +0000 (UTC)
From: "Kim Haase (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: <JIRA.12462883.1272040375711.34455.1377547911930@arcas>
In-Reply-To: <JIRA.12462883.1272040375711@arcas>
References: <JIRA.12462883.1272040375711@arcas>
Subject: [jira] [Commented] (DERBY-4629) Explicitly document  how to get
 case-insensitive sorts and comparisons of string data
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/DERBY-4629?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13750492#comment-13750492 ] 

Kim Haase commented on DERBY-4629:
----------------------------------

Rick, do you think that more is needed here in addition to the work on DERBY-4627 and DERBY-4628? Or would it still be helpful to have a topic on "Performing case-insensitive sorts and comparisons" in the "Localizing Derby" section, in addition to the one on "Creating a case-insensitive database" further up under "Working with the database connection URL attributes"? 

As near as I can tell, you must have a case-insensitive database in order to perform case-insensitive string sorts -- is that correct?
                
> Explicitly document  how to get case-insensitive sorts and comparisons of string data
> -------------------------------------------------------------------------------------
>
>                 Key: DERBY-4629
>                 URL: https://issues.apache.org/jira/browse/DERBY-4629
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions: 10.6.1.0
>            Reporter: Rick Hillegas
>            Assignee: Kim Haase
>
> The most frequently asked question about Derby's support for language-sensitive strings is this: "How do I get Derby to perform case-insensitive sorts and comparisons?" I think that the answer to this question could be figured out by a reasonably intrepid reader who understood a lot about Java's locale and collation support, perhaps supplemented with a fair amount of googling.
> If we made the answer to this question really pop out to the casual reader, then I think we would do a great service to our users and to developers and tech writers who answer questions on the community lists. Perhaps it would be sufficient to add a "Case-insensitive strings" section parallel to "Character-based collation in Derby" in the Developer's Guide.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira