MySQL 5.1.41 leading zero is deleted

Question

Hello,

I have a MySQL database where i want to store phonenumbers among other things.

The fieldtype is INT(10)

When I try to insert a number starting with a 0, like 0504042858 it's stored like 504042858. This only happens with zeros when the number start with any other number it's stored correctly.

What am I doing wrong?

Answer 1

You should probably store phone numbers as a varchar. Phone numbers are only numeric by accident.

You may also be interested in checking out the following Stack Overflow posts:

• What datatype should be used for storing phone numbers in SQL Server 2005?
• Common MySQL fields and their appropriate data types

Answer 2

it is removing the leading zero because mathematically they are the same and removing the leading zero is a quick storage optimization. In addition it also makes the numbers easier to read imagine a number padded with several leading zeros in a column of several hundred numbers.

I agree with Daniel change your column to a varchar.