Number input is changing in field

[KimS]

I have a field that is 10 digits. I made it unsigned. We put in over 150 records just fine. Now, the digits are changing when we save the record. For example:

the correct number is "8780769627" but the program changes it to "4294967295" - Why is this happening? :(

[xacto]

The program does not change it how could it do that. :rolleyes: The scripts won't change the data you enter in the databases.

You do not need to use unsigned. What datatype do you have for this field?
VarChar? Integer? What about field length?

[KimS]

The data type is integer and the length is 10. Any help is greatly appreciated!

[xacto]

Try using BIGINT (http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html) :D