I'm testing out MySQL 3.22.34-shareware-debug version, and have detected a problem when
sorting scandinavian characters (ÆÄØÖÅ). Is this a bug in
the shareware version, or a wrong/missing setting somewhere in the ini-file? My OS is
Windows 2000 Professional.
Here's a dump (from the command prompt), illustrating my problem:
=== dump start ===
mysql> use test;
Database changed
mysql> create table test (name varchar(30));
Query OK, 0 rows affected (0.01 sec)
mysql> insert into test (name) values ('Æ');
Query OK, 1 row affected (0.01 sec)
mysql> insert into test (name) values ('Ø');
Query OK, 1 row affected (0.00 sec)
mysql> insert into test (name) values ('Å');
Query OK, 1 row affected (0.00 sec)
mysql> select name from test order by name asc;
+------+
| name |
+------+
| Å |
| Æ |
| Ø |
+------+
3 rows in set (0.01 sec)
=== dump end ===
The correct order should be Æ-Ø-Å...
Thanks in advance for any help.
-Bjarte-