[DERBY-554] ORDER By clause doesn't work with national strings

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 10.1.1.0
• Component/s: JDBC
• Environment: Win XP, JDK 1.5
• Assignee: Unassigned
• Reporter: Libor Krzyzanek
• Created: 02/Sep/05 23:24
• Updated: 29/Mar/07 23:40
• Resolved: 29/Mar/07 23:39

Description

ORDER By clause doesn't work with national strings. When sort column with strings with national chracters (Czech = cs_CZ locale) , it doesn't sort properly (special characters is on the end of the alphabet but should not be).

How to resolve the problem:
For national ordering just use java.text.Collator to compare strings.

Sysinfo:
------------------ Java Information ------------------
Java Version: 1.5.0_04
Java Vendor: Sun Microsystems Inc.
Java home: C:\Program Files\Java\jre1.5.0_04
Java classpath: derby.jar;derbytools.jar
OS name: Windows XP
OS architecture: x86
OS version: 5.1
Java user dir: c:\develop\jars\db-derby-10.1.1.0-bin\lib
java.specification.name: Java Platform API Specification
java.specification.version: 1.5
--------- Derby Information --------
JRE - JDBC: J2SE 5.0 - JDBC 3.0
[C:\develop\jars\db-derby-10.1.1.0-bin\lib\derby.jar] 10.1.1.0 - (208786)
[C:\develop\jars\db-derby-10.1.1.0-bin\lib\derbytools.jar] 10.1.1.0 - (208786)
------------------------------------------------------
----------------- Locale Information -----------------
------------------------------------------------------

Issue Links

• duplicates: DERBY-1478 Add built in language based ordering and like processing to Derby