Re: Danish/Norwegian collation and 'aa' = 'å' when sorting
Posted by: Peter Gulutzan
Date: May 15, 2006 12:44PM

Are you saying that that is what you want?
If so, perhaps you could try Unicode instead.

mysql> set names utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> create table x (s1 varchar(10) character set utf8 collate utf8_danish_ci);
Query OK, 0 rows affected (0.06 sec)

mysql> insert into x values ('Aadne'),('Adam'),('Benjamin'),('Åge');
Query OK, 4 rows affected (0.00 sec)
Records: 4 Duplicates: 0 Warnings: 0

mysql> select * from x order by s1;
+----------+
| s1 |
+----------+
| Adam |
| Benjamin |
| Aadne |
| Åge |
+----------+
4 rows in set (0.00 sec)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Danish/Norwegian collation and 'aa' = 'å' when sorting
2399
May 15, 2006 12:44PM


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.