Sorting with icelandic letters

[Logi P]

Hello there,

I'm not a newbie to Mysql but have a problem I have not been able to fix.

I need to sort icelandic names. And it's always wrong! I have messed with collations and chartsets for a long time and nothing seems to solve the problem. The setup now (straight from the command line):

mysql> show variables like '%coll%';
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | utf8_icelandic_ci |
| collation_database | utf8_icelandic_ci |
| collation_server | utf8_icelandic_ci |
+----------------------+-------------------+
3 rows in set (0.03 sec)

and the table I have to sort also most definately has the same collation.
Still I get:.... Ólöf, Örn, Ragnar, Rúnar .... from the query:

SELECT * FROM contact_directory order by first_name;

Ok you probably don't know the icelandic alphabet! But the Ö is the last letter in it. And this is the uni's phone directory and it makes us look rather bad...

PLEASE give some advice. I have been on this for days and running out of ideas.

best regards, Logi

PS. I´m using 5.0.18 for win32