Problem with swedish characters...

[Johan Andersson]

Hi

I don't understand how MySQL sort table values beginning with a swedish character.

My MySQL version is 4.1.8 with variables;
character_set_server = latin1
collation_server = latin1_swedish_ci

I create a test table using the command mysql> create table test (name varchar(20));
I populate the table with the following (swedish) names; Carl,Martin,Sven,Adam,Åke,Ärland,Östen
Now issuing a mysql> select * from test order by name; I get the following result
+--------+
| name |
+--------+
| Adam |
| Ärland |
| Åke |
| Östen |
| Carl |
| Martin |
| Sven |
+--------+
7 rows in set (0,01 sec)

For those unfamiliar to the swedish alphabet, the proper sort order is A,B,C.,..Y,Z,Å,Ä,Ö

So I was of course expecting the result:
Adam
Carl
Martin
Sven
Åke
Ärland
Östen

To check, I issue: mysql> show table status;
and there is appears that for my newly created table 'test', the collation is latin1_swedish_ci (as it should)

Anyone knows what the problem is?!