Very strange behaviour in primary key field!!

Scriptcase 9 General
#1

I have a table with a primary key field (Code) type (int(11)), value insert manually.
When i insert this value: 30201010 it goes well and saved without any problem, When i insert 3020101010 the data saved but the number in the primary key field changed to 2147483647 !!!
So 3020101010 will be 2147483647 after record save :wink:

Please help …

#2

Because its the max positive number for a signed int.
http://en.m.wikipedia.org/wiki/Integer_(computer_science)

#3

Thanks so much (Giu). Appreciate your help.