MySQL Forums
Forum List  »  Character Sets, Collation, Unicode

Advanced Search
New Topic

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?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Sorting norwegian names problem aa, a, b, æ, ø, å... aa is sorted before a, should be like å
16199
Tore Krudtaa
November 15, 2007 03:25AM
Re: Sorting norwegian names problem aa, a, b, æ, ø, å... aa is sorted before a, should be like å
7662
Peter Gulutzan
November 15, 2007 08:48AM
Re: Sorting norwegian names problem aa, a, b, æ, ø, å... aa is sorted before a, should be like å
5662
Tore Krudtaa
November 16, 2007 04:58AM
Re: Sorting norwegian names problem aa, a, b, æ, ø, å... aa is sorted before a, should be like å
4747
Peter Gulutzan
November 16, 2007 03:25PM


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.