db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-554) ORDER By clause doesn't work with national strings
Date Thu, 06 Oct 2005 00:09:50 GMT
    [ http://issues.apache.org/jira/browse/DERBY-554?page=comments#action_12331448 ] 

Rick Hillegas commented on DERBY-554:
-------------------------------------

This should be fixed when we re-enable the national character string types: NCHAR and NVARCHAR.

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

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message