db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-4629) Explicitly document how to get case-insensitive sorts and comparisons of string data
Date Tue, 27 Aug 2013 12:31:52 GMT

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

Rick Hillegas commented on DERBY-4629:

Hi Kim,

To answer your question, I refreshed my docs client and rebuilt the docs. Then I went to the
Developer's Guide to look up the material on how to get Derby to sort data in a case-insensitive
way. The first place I looked was in the table of contents under "Localizing Derby". I think
that a lot of people will go to that section first. Many people coming from other databases
will think of sort-order as an attribute of individual table columns, not a bulk attribute
of the entire database.

However, the material is under the "Working with the database connection URL attributes" topic.
This probably makes a lot of sense for people who are familiar with Derby. But newbies aren't
going to know to look for case-sensitivity information under a topic on connection URLs. If
only we had a document index, this would be less of a problem.

I think that people will look for this material in a couple places:

1) Where I initially looked, under "Localizing Derby" in the Developer's Guide.

2) In the Reference Guide section titled "Data type assignments and comparison, sorting, and

3) Maybe even under the "CREATE INDEX statement" topic in the Reference Guide.

At a minimum, I'd recommend adding pointers from the above topics to the relevant material.
I think that the pointers for (1) are handled by the work you did on DERBY-4627. We could
probably do with some pointers for (2) and (3).

But at the end of the day, it would really be great if this material popped when you scanned
the table of contents. I wonder if it's worth putting a dummy section under "Localizing Derby"
just so that it pops when the reader looks there. The dummy section could just forward the
user to the relevant material. On the other hand, that would be trying to make the table of
contents function like an index and so is the beginning of a slippery slope which we may regret

Those are my $0.02. Thanks.

> 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:
>            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
> 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

View raw message