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

Warning message
I've put a website that I was doing live and I'm getting this warning message when I try to add a ne

please fix the error
What is the error in the below code ???
Line number On/Off | Expand/Contract <?php

DataTable Help Required
Hi all I am creating an app that utilises and MS Access back end and queries it quite a bit at vario

Curly Bracket Delimeters.
I'd always believed that the starting and ending delimeters in preg_ functions had to be the same ch

Extracting Long text from message class with parameters
Hi,

I would like to extract the long text from a message class. However, the long text ha

WELCOME SCREEN
first of all let me tell you what does my script do,

it´s a very simple query to show a e

parameter passing issue on function
Well I thought I had created a pretty slick web page, using ?page and $_GET to load pages which wher

passing data from one page to another
hey guys
i have the follwoing code to get information from one page and place on another:

How to calculate days from variable date?
This will be easy for one of you gurus. I want to fetch the date from a variable date, for example:<

php email checker
I am having alot of trouble finding info on how to do these email things. I need to do the following