Comparing Numbers in Text Fields

2005-10-12 Thread zzapper
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? -- zzapper Success for Techies and Vim,Zsh tips http://SuccessTheory.com/ -- MySQL

Re: Comparing Numbers in Text Fields

2005-10-12 Thread Neculai Macarie
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

Re: Comparing Numbers in Text Fields

2005-10-12 Thread zzapper
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