You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Libor Krzyzanek (JIRA)" <de...@db.apache.org> on 2005/09/02 16:26:31 UTC
[jira] Created: (DERBY-554) ORDER By clause doesn't work with national strings
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
Re: [jira] Created: (DERBY-554) ORDER By clause doesn't work with
national strings
Posted by Mike Matrigali <mi...@sbcglobal.net>.
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 -----------------
> ------------------------------------------------------
>
[jira] Closed: (DERBY-554) ORDER By clause doesn't work with
national strings
Posted by "Daniel John Debrunner (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-554?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Daniel John Debrunner closed DERBY-554.
---------------------------------------
Resolution: Duplicate
Duplicate of DERBY-1478
> ORDER By clause doesn't work with national strings
> --------------------------------------------------
>
> Key: DERBY-554
> URL: https://issues.apache.org/jira/browse/DERBY-554
> Project: Derby
> Issue Type: Improvement
> Components: JDBC
> Affects 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.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-554) ORDER By clause doesn't work with
national strings
Posted by "Daniel John Debrunner (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-554?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12485383 ]
Daniel John Debrunner commented on DERBY-554:
---------------------------------------------
Removed link to issue for enabling national characters as collation is independent of national character types.
> ORDER By clause doesn't work with national strings
> --------------------------------------------------
>
> Key: DERBY-554
> URL: https://issues.apache.org/jira/browse/DERBY-554
> Project: Derby
> Issue Type: Improvement
> Components: JDBC
> Affects 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.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-554) ORDER By clause doesn't work with national strings
Posted by "Rick Hillegas (JIRA)" <de...@db.apache.org>.
[ 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