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 <[EMAIL PROTECTED]>
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
