sql error out of range value for column code example

Example: c# mysql value out of range exception

/*
The value 3172978990 is greater than 2147483647 – the maximum value for INT – hence the error. 

Also note that the (10) in INT(10) does not define the "size" of an integer. 
It specifies the display width of the column. This information is advisory only.

To fix the error, change your datatype to VARCHAR. 
Phone and Fax numbers should be stored as strings
*/