Re: Collation and sort order of uft8_swedish_ci

[Peter Gulutzan]

Hi,

The results are not reproducible.

I tried this. I have MySQL 5.1.41 but we haven't changed this in a long time.

set names utf8;
create table songs (title char(20) character set utf8 collate utf8_swedish_ci);
insert into songs values (0x50C3844956494E20C396494E);
insert into songs values (0x50C3844956494E20C396494E);
insert into songs values (0x50415252415356414C4F54);
insert into songs values (0x504944C384204B49494E4E49);
insert into songs values (0x5049454E455354C38420504954C384454E);
insert into songs values (0x5049494B4B494C414E4B4141);
insert into songs values (0x50494D45C3845354C3842056414C4F4F4E);
select title from songs where title like 'p%' order by title;

The result of the SELECT was:

+-------------------+
| title |
+-------------------+
| PARRASVALOT |
| PIDÄ KIINNI |
| PIENESTÄ PITÄEN |
| PIIKKILANKAA |
| PIMEÄSTÄ VALOON |
| PÄIVIN ÖIN |
| PÄIVIN ÖIN |
+-------------------+
7 rows in set (0.02 sec)

Peter Gulutzan
Sun / MySQL