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

Unable to retreve the values from Mysql Query
Hi,

Here is the php code that I have, Query is running properly in phpmyadmin and is resu

Consuming third party Payment Gateway API from Procedure.
Hi All,

First of all i would like to thank all the people of the oracle forum for providi

Random date selection
i want to select random date with time(hour+minutes+sec) where date is specified(10/22/2009) and tim

Does deleting the spmlog directory critical?
Hi Everyone,

Please, hope you could help me. We're having problems with the SAP backup. I

values in array being escaped
I would like to submit some values - back to the same form for checking before processing...

Count number of records in all the tables with a querry URGENT PLEASE...
I downloaded ORACLE 9I DATA DUMP into my comp. There are number of tables. I need to find out the

Save username into DB
OkaY so I got my blog to actually save the posts and whatever, all I need now is for it to keep the

error checking breaking my code
Hi there, OK first of all, big apologies for what I assume is really fundamental errors in the struc

Log $_POST
How would i log submits on a form, by everyone? I want to then echo the number of submissions.

Do not allow posting of whitespace
Currently the script below works if the user does not type a name/message, but if i create a whitesp