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

help with insert
Hi there,

I am trying to insert some data into a database, but for some reason, it is not ins

New to Arrays
Hi I am new to PHP (a week and a half now) and I am just beginning to read about arrays. I understan

post to self
Trying to get my form to submit to itself. However I am also trying to use an image for my submit bu

upload photo limits
ive got a upload photo script and im just trying to make more secure currently it limits size and as

MySQL query problem
When I try to run the following piece of code, I get this error:
QuoteWarning: mysql_query(): sup

Putting double spaces instead of single spaces
Im looking at trying to replace all single spacing between fields with double spacing

At pres

Undefined offset
The following script checks to see if the user answer matches the correct answer.

Form Fiel

php automatically escaping single quotes
I'm trying to test out my security a bit and I've noticed that php is escaping my single quotes. For

Calander layout
Hi i know this sounds like a simple question but i cant find the answer to it anywhere i have added

Solution Manager BPR
Does the SolMan-BPR-ARIS-Integration (http://www.ids-scheer.com/en/ARIS/ARIS_Platform/ARIS_Business_