Re: Danish/Norwegian collation and 'aa' = 'å' when sorting

[Peter Gulutzan]

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)