Danish/Norwegian collation and 'aa' = 'å' when sorting
Posted by: Ivar Sund
Date: January 06, 2006 03:53PM

Is it true that the danish/norwegian collation DOES NOT weight 'aa' and 'å' the same in an 'order by'? In this collation, 'aa' and 'å' is treated as equal when sorting:

Row values in table x:
Aadne
Adam
Benjamin
Åge

Order by results in:
Adam
Benjamin
Aadne
Åge

If this is suppost to work, what am I doing wrong? The database is the latest 5.0 release, and I have set the encoding to latin1 and collation to danish.

Options: ReplyQuote


Subject
Views
Written By
Posted
Danish/Norwegian collation and 'aa' = 'å' when sorting
5435
January 06, 2006 03:53PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.