Menu
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?
664
To fix the issue, we will have to store a less than 2147483647 or change the data type of student_ssn_no to BIGINT. Let us modify the column to BIGINT and try inserting the data again. As we can see in the above image, student_ssn_no for row 1 got inserted without any error now.
To fix the error, change your datatype to VARCHAR . Phone and Fax numbers should be stored as strings.
Out of Range (OOR) Indicators For example, if you have a machine reading that is useful in a range from 10 to 90, you may not know or care if the value is 5 or 6, just know that it is out of range, and may be output by the machine as "<10".
Just end the command with a semicolon ";". MySQL will display an error message and let you continue.
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 Is it better to store telephone numbers in some canonical format or "as entered"?
100
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?
28
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
