On Wed, 12 Oct 2005 13:27:52 +0200, wrote: >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 />
Mack, I guess you are right, as coincidentally, I recently had the same problem with MS-Access DB where a search for largest number in a column worked until the largest number exceeded 999, thereafter 999 was seen as greater than 1000.. -- zzapper Success for Techies and Vim,Zsh tips http://SuccessTheory.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
