Let us take a practical example.
You want to define a column, city.
How many characters do you think this column will have?
Say a maximum of 40.
Then think of User Interface. Suppose if this column is displayed on the screen for user input, do you want to allocate 4000 characters or 40 characters?