Re: Sorting norwegian names problem aa, a, b, æ, ø, å... aa is sorted before a, should be like å
Posted by: Tore Krudtaa
Date: November 16, 2007 04:58AM

Hi Peter

I get exactly the same result as you.

And that is the problem.

aa should be treated as an å (for us norwegians).

So if you have these 'words';

aakkar
aarri
alfa
bravo
ærlig
østen
åse
åke
ålborg

then the sorting in Norwegian should be like this:

alfa
bravo
ærlig
østen
åke
aakkar
ålborg
aarri
åse

Ref this thread it looks like there should have been another special collation for danish that treats the aa exactly like an å.
http://bugs.mysql.com/bug.php?id=31351

Is this in the works or will it not be done?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Sorting norwegian names problem aa, a, b, æ, ø, å... aa is sorted before a, should be like å
5550
November 16, 2007 04:58AM


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.