Sorting norwegian names problem aa, a, b, æ, ø, å... aa is sorted before a, should be like å

[Tore Krudtaa]

Hi.

I'm having some problems with aa being sorted before a,b,c

As far as I know It (aa) should be sorted like an å.
So in my sorted list the names starting with aa should be sorted just like if the aa was replaced with an å.

using this for create table:
ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_danish_ci;

and this for the char field:
char(40) COLLATE latin1_danish_ci NOT NULL

Then when I order by the char field I get result like this:

Aasen
Åatute
Alfa
Bravo
Charlie
Ærlig
Østen
Åbrekke

And shouuld have been like this:

Alfa
Bravo
Charlie
Ærlig
Østen
Åbrekke
Aasen
Åatute

It this due to some quirks with the danish collation not treating the AA aa Aa correct for us Norwegians?

Or have I done something wrong in relation to charset and collation?

Is there a way to get this working today?
Or is this an issue that will be sorted out in some future version of MySQL?