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

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”?

Leave a Comment