|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#1
|
|||
|
|||
|
Cannot make sorting against Norwegian letters work. Help?
Okay..
I have created an UDF to be able to use a collation when sorting I want to sort records that contain Norwegian letters. Database is in UTF-8 If I do this: select PAG_ID,PAG_NAME from pager where lower(PAG_NAME) like 'a%' order by ICU.SORTKEY(PAG_NAME, 'LNB') (where LNB is the collation) then the records are ordered like this: Aø Aæ Aå If I do this: select PAG_ID,PAG_NAME from pager where lower(PAG_NAME) like 'a%' order by ICU.SORTKEY(PAG_NAME, 'LNB_AS') then the records are ordered like this: Aå Aø Aæ The records should have been in this order: Aæ Aø Aå This is the only database I have trouble getting this to work. Does someone know how to make this work. I do want to store the data in a UTF8 database though. the default "Norwegian Bokmål" collation to use is LNB It is possible though to add some attributes to the LNB string to change how to order the records.... So when I use LNB_AS it is different that default sort order. I have played around with the attributes but without getting it to work. If anyone know how to do this I would be happy to see an explanation here.
__________________
BongoBongo Last edited by phpweb : November 30th, 2006 at 07:02 AM. |
![]() |
| Viewing: Dev Shed Forums > Databases > DB2 Development > How do I sort according a given collation in DB2 |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|