Numbers change when inserting into the database, how to fix it?

Question

MySQL

The field type is INT, the numbers come with a POST request, I enter into the database, and in the database it’s not what I entered, but numbers like "2147483647". Lines transfers normally and if you change the field type in the database to varchar - it is displayed normally.
What's wrong?

Answer 1

most likely numbers come big than it is admissible for int'a. Increase the field size for example to bigint