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

Feed Maker
Hi all.
First of all I must say I am not a php developer so I am afraid I don't know much about i

replacements
I have a variable in my PHP script like

ASSFDDDDDDDDDDDDDASDDDDDDDDARYTRHKKHHHHHHHHHHH and p

Polymorphism
Was wondering if someone could explain this a little better to me. I had always assumed that it had

Taylor Series Function
So I am working a a project for my intro C++ class, and I am having some trouble with a function for

Move array index to end
Hey guys,
Quick question:

I have an array that looks like this:
Code: [Select]$var =

Creating a custom API
I'm creating a site, and I need to create a basic API. Unfortunately I have no idea where to start.

Upload Code Help
Hi everyone I need some help with a bit of code ive been working with for a while. I am completely s

please help
HTML Code:

Code: <span id="ctl00"><span>

update the selected existing records of database
Hi frndz,
I am new to php and get stuck....

Edit.php > Update.php > Updatea

Writting a script to arrange images........ need some help
Ok so here is the link

http://hmtotc.com/dev/projects/vrassociates/jeweler_dev/admin/index.ph