I would say this is not a bug. You declared an enum for the column. So
therefore it sorts in enum order. Makes perfect sense. To me MySql is
working correctly. If it did not sort an enum in the order declared for
the enum then i would be annoyed. Enums are not strings.
Declare the column as varchar if you wish to sort _alphabetically_.
On Wed, 08 Jun 2005 23:38:18 +0100, Daevid Vincent <daevid@stripped>
wrote:
> Please tell me there is a way to fix this "bug" in mysql Ver 12.22
> Distrib
> 4.0.18, for pc-linux-gnu (i686)
>
> I have a column defined like so:
> Type
> enum('Schedule','Report','Admin','Search','General','License','Access')
>
> If I SELECT, and ORDER BY Type, it is ordering in the order defined by
> the
> the ENUM, not _alphabetically_ as a sane person would expect. UGH!
>
> Please tell me there is a fix or work around.
>
>
--
alex
tel
02380 48 8273
