db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Libor Krzyzanek (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-554) ORDER By clause doesn't work with national strings
Date Fri, 02 Sep 2005 14:26:31 GMT
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  
 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.

------------------ 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-\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-\lib\derby.jar] - (208786)
[C:\develop\jars\db-derby-\lib\derbytools.jar] - (208786)
----------------- Locale Information -----------------

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
For more information on JIRA, see:

View raw message