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 gues

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 (numbe

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/ -- MySQ