Might be Database Problem

jaduser

Hello Guyz...

I am working on an application.Which insert user mobile number in mysql database.The datatype for that field is "varchar" now i am inserting something like
01195363636

but database not saving 0 .only this number = 1195363636 in this column

on the other hand if i have 01195363636 number in same column then it's not showing number with 0 on php page.

i dont know what's happening.

Any Help

jAD

johanafm

Sounds like the phone number is treated as a number at some point, instead of a string.

jaduser

well user enters his phone number and my application sends a sms to that number.I store the number in db but some how 0 is not going into the db and not even coming from db.if i already have a number starting from 0 then when i fetch the record set 0 is missing..

plz help

jaduser

Even if i am working with BIGINT in mysql datatype still 0 is not going and coming from db.

johanafm

I still claim that the phone number is treated as a number (int/whatever) at some point, instead of remaining a string all the way from user to DB, and then all the way from DB and back to user again.

Using a BIGINT in the DB is definitely proving my point, as that is indeed treating data as a number instead of a string. Change it back to VARCHAR, then go over the rest of the code and make sure you stick to strings all the way.

Roger_Ramjet

Silent type conversion - often a boon but in this case a bane.

It can also happen in the database, but this is only when you perform eg: a sting operation on a number. Other than that, mysql will just take the type from the column definition.