I am learning of the different types of colum types in MySQL and I don't understand why there are different vesions of most of them. Like TEXT, which has a maximum length of 65535 characters and MEDIUMTEXT, which has a a maximum length of 16777215 characters. (And then there is LONGTEXT as well.)

What is the point of them? Why not just always use MEDIUMTEXT or LONGTEXT, so you'll be sure never hit a wall with to many charactrs. The same tthing goes for TINYINT/SMALLINT/MEDIUMINT/INT etc.

Can someone explain it to me?