Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-1478

Add built in language based ordering and like processing to Derby

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.1.2.1
    • Fix Version/s: 10.4.1.3
    • Component/s: SQL
    • Labels:
      None

      Description

      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

        Attachments

        1. DERBY-1478_FunctionalSpecV1.html
          5 kB
          Mamta A. Satoor
        2. DERBY-1478_FunctionalSpecV2.html
          5 kB
          Mamta A. Satoor
        3. DERBY-1478_FunctionalSpecV3.html
          5 kB
          Mamta A. Satoor
        4. DERBY-1478_FunctionalSpecV4.html
          6 kB
          Mamta A. Satoor
        5. DERBY-1478_FunctionalSpecV5.html
          6 kB
          Mamta A. Satoor

          Issue Links

          There are no Sub-Tasks for this issue.

            Activity

              People

              • Assignee:
                mamtas Mamta A. Satoor
                Reporter:
                kmarsden Kathey Marsden
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: