We are facing sort problems with DB2 V18.104.22.168 on Linux.
When we launch the following query:
select * from PROJECT order by NAME
we get the result you can find in the attachment sortProblem.xls
Is there any reason why we get the uppercase letters before the lowercase letters?
Is there any way we can change this?
We are at the following db2level:
DB21085I Instance "db2inst" uses "32" bits and DB2 code release "SQL09053"
with level identifier "06040107".
Informational tokens are "DB2 v22.214.171.124", "s081118", "MI00255", and Fix Pack
Product is installed at "/opt/IBM/db2/V9.5".
Many thanks in advance!
This topic has been locked.
2 replies Latest Post - 2012-11-16T09:56:29Z by SystemAdmin
Pinned topic Sort problem with DB2 V126.96.36.199 on Linux
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-11-16T09:56:29Z at 2012-11-16T09:56:29Z by SystemAdmin
Re: Sort problem with DB2 V188.8.131.52 on Linux2012-11-16T09:56:29Z in response to SystemAdminHi Tony,
Probably something to do with the collating sequence you used when creating the database and/or the type of the NAME field in the PROJECT table.
Can you post your DB related parameters and the DDL of PROJECT table?