I always thought that the number in the parenthesis represented the field length?

However, I understand that is not always the case. Maybe it's a MySQL issue? Someone told me if I set a field to 9 characters long, I can add a value that's more than 9 characters but only the first 9 will be saved.

Example:

CREATE TABLE `person` (
    id INT,
    age INT(2)
);

If that's the case, shouldn't I select something like TINYINT instead of INT for age?

mysql sql ddl
Edit
Report