Not have a minimum MySQL INT Value

Question

When I add a number beginning with 0 into my MySQL database, it automatically gets converted to a single digit. These are mobile numbers, so I need to keep it starting with 0.

score 3 · Answer 1 · edited May 23 '17 at 11:48

3

Store phone numbers as strings, not integers. (related: Common MySQL fields and their appropriate data types )

edited May 23 '17 at 11:48

Community

1
1

answered Jun 05 '11 at 21:12

Wooble

87,717
12
108
131

score 1 · Answer 2 · answered Jun 05 '11 at 21:14

1

Try storing the numbers as varchars instead. When you retreive them from the database you could cast them using (int) if needed.

answered Jun 05 '11 at 21:14

Not have a minimum MySQL INT Value

2 Answers2