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.

Community · Accepted Answer · 2017-05-23 11:48:03Z

3

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

edited May 23, 2017 at 11:48

CommunityBot

11 silver badge

answered Jun 5, 2011 at 21:12

Wooble

90.5k12 gold badges111 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user784316 · Accepted Answer · 2011-06-05 21:14:16Z

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 5, 2011 at 21:14

user784316

Collectives™ on Stack Overflow

Not have a minimum MySQL INT Value

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related