Why is it that when you drive in a number more than 10 characters, only 10 and others are saved?

Question

PHP

Why, when adding a number greater than 10 characters, in my case 14, only 10 is kept and the value is completely different?
How to store a number to 15-20 characters?

Initially, the column was created as int(32) DEFAULT NULL, and after as int(64) DEFAULT NULL, but this did not change anything.

Answer 1

How to store a number to 15-20 characters?

Use BIGINT [UNSIGNED]
www.mysql.ru/docs/man/Column_types.html

Answer 2

32 and 64 in your case is not the bit depth of the stored number. This is the length of the output when displayed.