I believe DERBY-533 would address this issue.
Libor Krzyzanek (JIRA) wrote:
ORDER By clause doesn't work with national strings
--------------------------------------------------
Key: DERBY-554
URL: http://issues.apache.org/jira/browse/DERBY-554
Project: Derby
Type: Improvement
Components: JDBC
Versions: 10.1.1.0
Environment: Win XP, JDK 1.5
Reporter: Libor Krzyzanek
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 -----------------
------------------------------------------------------
