mysql a order by na enum a varchar

[Martin Caslavsky]

Dobry den,

nasledujici sekvence prikazu

create table pokusorder (stav enum('A','N','P'), nazev varchar(40));
insert into pokusorder values ('A', "b");
insert into pokusorder values ('A', "a");
select stav, nazev from pokusorder order by stav, nazev;

mi v mem mysql 3.23.36  vrati:
+------+-------+
| stav | nazev |
+------+-------+
| A    | b     |
| A    | a     |
+------+-------+

Proc neni "a" pred "b"? (Mimochodem to vraci stejny vysledek, i kdyz ty
inserty prohodim.)

                             Martin Caslavsky
= mcaslavsky na macroware.cz == tel. 0603 872477 =
= MACROWARE s.r.o.   http://www.macroware.cz  =
==========    Vas WEB na nasi hlavu     =======