Text column sizes in MySQL

Postgres works differently

See PostgreSQL: Difference between text and varchar columns for PostgreSQL-specific info

MySQL has 4 different column sizes. They are actually different data types under the hood:

You can also specify a column size with the limit option. This will take an integer value in bytes and convert it to the next biggest available column type that can accommodate this amount of data.