How to remember a leading zero?

[brad62]

I think I read this somewhere but can't find how to solve it now.
I have a field in my PHP/MySQL form for a mobile number.
It starts with a zero, but when it ends up in MySQL the zero
disappears. How do I make it keep that zero?

Is there a solution to make it remember even if it is starting
with double zero as well? Just curious.

[brad62]

I have tried to make it as a VARCHAR but now I discovered something else.
When I put more than 10 numbers it ends up with the following number: 2147483647
I wrote 1234567812345678 but the above number came up???

[brad62]

Sorry, I found out what was wrong. I had put the post as an int instead of a TEXT.
But still wondering how to make a number with a leading zero to keep the zero/zeros.

[rightinpoint.com]

let it be float
or store as text + use special lib for the operation with the long decimals

[HardCoded]

Use a text type, like CHAR(16). An INT type is definitely not what you want for phone numbers.