zzapper wrote: > Hi, > Recently had a few problems with comparing numbers stored in text > mysql fields char(2), which I solved by chnging the field to int(1) > > Now my question is why do you sometimes "appear" to get away with > this?
My guess is that if the numbers are of the same length (number of characters) then the alpha sorting works ok. -- <mack /> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]