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

Coefficient of a Restitution Hints
Hello. I was wondering if anyone can give me hints on how to write this program...

The coeffi

UTL File problem
Hi
I have a file in certain path with the following permissions (The file is a dummy file witho

Points for Wiki contribution
Hi everyone,

I want to know how long does it take for the moderator to award points for a

Tree Menu
Hi guys,

Can anyone help me making a tree navigation system? I have a site where I'm allowin

Using Microsoft Exchange Server with PHP
Hi,

I wanted to know if its possible to fetch email attachments from the exchange server usin

Transport data between itab and textfield on ALV event
Hallo,

I have a ALV Grid ( cl_gui_alv_grid ) and I also have hotspot click event with a h

Create multiple (n) arrays
Hi there,

I have the following need:

I have 2 arrays (coming from a databases)

Create comparison matrix?
I want to create a comparison script for forum software and was wondering is there any tutorial or b

How to add advertisment on top of videos
Hello,
I was told that i should find the answer for this problem in this forums.
I searched a

upgrade from 4.7 to ECC 6.0
Hi all,
we are going to do an upgrade from R/3 4.7 to ECC 6.0. I need to know if i can find som