c# mysql value out of range exception
snippet in sql

c# mysql value out of range exception

user3713

/*
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
*/