Sorting with icelandic letters
Posted by: Logi P
Date: March 30, 2006 11:18AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Sorting with icelandic letters
5315
March 30, 2006 11:18AM


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.