mysql VARCHAR acting like INT

Posted on 16th Feb 2014 07:03 pm by admin

Hi, All.

I have a table that contains a varchar(10) column named weird_field. In this column, only integers reside (e.g., 3010101009). When I do this:

Line number On/Off | Expand/Contract select * from table where weird_field = '3010101009'

no records are returned, even though there is a record with weird_field = '3010101009'.

However, if I do this:

Line number On/Off | Expand/Contract select * from table where weird_field = 3010101009

the appropriate records are returned. I don't think this should be the case, right? Because it's a varchar column, shouldn't the 3010101009 be quoted? It's messing up some joins I'm trying to do, and I just don't get it.

Thanks

Your Answer:

Login to answer

Other forums

Session is not saving
I am not trying to do anything too fancy, I am just trying to get some $_SESSION data to save and us

reading xml faster than DB call?
I am trying to optimize a high traffic website, and I enabled a feature where there are three photos

Standard DES encryption script?
Can anybody point me to a tutorial or a short script that shows how to encrypt some text with salt i

Comparing Values
Hi
I'm reading data from a database and this seems to work OK.

Each system has an associat

PHP/Database issue
My friend is helping me make a database where you go to a certain webpage of my site and the page wi

does anyone know a php script to send mail using gmails/googles free smtp server
cause i heard u can do that but i dont know how

Motivational Posters
Hello,

I wonder how can i do them in php. Are there any sample codes that you can show me?

Displaying Multidimensional Arrays...about to put my head in a vice, PLEASE HELP
I am fairly new to PHP and MySQL and I have a problem which I have been trying to resolve for days.

keeps going back to index.html ???????
ok so i started making my site using mostly.html files now i have added a fair chunk of php. My inde

problem with sql querry in php script
Hello guys,

What I want to do is I want to read out a csv file and then but te conent ot the