[Solved] Issue in saving contact number into database [duplicate]

Question

INT has a max value of 2147483647 (or 214-748-3647).

So, 555-555-5555 will get rewritten to the max it can store.

Phone numbers are NOT integers, so you shouldn’t store them like that. All sorts of problems can happen – 055-555-5555 would be stored incorrectly as 55-555-5555, 555-555-5555 x1234 can’t be entered, etc.

Accepted Answer

INT has a max value of 2147483647 (or 214-748-3647).

So, 555-555-5555 will get rewritten to the max it can store.

Phone numbers are NOT integers, so you shouldn’t store them like that. All sorts of problems can happen – 055-555-5555 would be stored incorrectly as 55-555-5555, 555-555-5555 x1234 can’t be entered, etc.