List:MySQL on Win32« Previous MessageNext Message »
From:Bjarte Husebø Date:June 1 2000 1:10pm
Subject:Problem with sorting scandinavian characters
View as plain text  
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-



Thread
Problem with sorting scandinavian charactersBjarte Husebø1 Jun
  • Re: Problem with sorting scandinavian charactersSinisa Milivojevic1 Jun
    • Re: Problem with sorting scandinavian charactersJani Tolonen4 Jun
  • Re: Problem with sorting scandinavian charactersBjarte Husebø2 Jun
    • Re: Problem with sorting scandinavian charactersmiguel solórzano2 Jun
  • Re: Problem with sorting scandinavian charactersBjarte Husebø4 Jun
    • Re: Problem with sorting scandinavian charactersJani Tolonen5 Jun
  • Re: Problem with sorting scandinavian charactersBjarte Husebø5 Jun
    • Re: Problem with sorting scandinavian charactersJani Tolonen6 Jun
      • Re: Problem with sorting scandinavian charactersJani Tolonen6 Jun
        • Re: Stupid TV junk...Jonah H. Harris6 Jun
Re: Problem with sorting scandinavian characters(Regis Bossut)6 Jun
  • Re: Problem with sorting scandinavian charactersSinisa Milivojevic7 Jun
    • Re: Problem with sorting scandinavian characters(Regis Bossut)7 Jun
      • Re: Problem with sorting scandinavian characterssinisa7 Jun