those numbers in parentheses behind some datatypes might be making you think that they somehow “limit” the number of characters or digits that the column can hold
this is ~not~ what they do for integer datatypes
INT(4) and INT(10) and INT(937) will all hold exactly the same range of numbers
the numbers in parentheses behind CHAR and VARCHAR are required and ~do~ limit the length of the values
numbers in parentheses behind TEXT and BLOB and their similar datatypes are not permitted
If you use it with a padding option then the number gets padded out to the specified length if it is shorter. If you don’t use it with a padding option then it makes no difference at all.