mysql datatype for telephone number and address

Well, personally I do not use numeric datatype to store phone numbers or related info.

How do you store a number say 001234567? It’ll end up as 1234567, losing the leading zeros.

Of course you can always left-pad it up, but that’s provided you know exactly how many digits the number should be.

This doesn’t answer your entire post,
Just my 2 cents

Leave a Comment