How do I fix the 'Out of range value adjusted for column' error?

Question

Hello,

I went into phpMyAdmin and changed the value for an integer(15)field to a 10-digit number, so everything should work fine. I entered the value '4085628851' and I am receiving the following error:

Warning: #1264 Out of range value adjusted for column 'phone' at row 1

It then changes the value to '2147483647'.

After some googling, I found this article that explains how to fix the problem. http://webomania.wordpress.com/2006/10/01/out-of-range-value-adjusted-for-column-error/, but I don't know how to login to the Mysql shell.

How do I login to the Mysql shell? How do I fix this error?

Answer 1

The value you were trying to set is too large for a signed INT field. The display width (15) does not affect the range of values that can be stored, only how the value is displayed.

Ref: MySQL Docs on numerics

On phone numbers - see http://stackoverflow.com/questions/1547920/is-it-better-to-store-telephone-numbers-in-some-canonical-format-or-as-entered

Answer 2

I just changed the field type to BIGINT, and that fixed the problem. I guess i cant enter a value above 2147483647 for an INT, so I assume everyone who uses a field to enter a 10-digit phone number uses a BIGINT?