The only storage size difference is the number of bytes allocated for the “how many bytes is this field” number. From the fine manual:
TINYTEXT L + 1 bytes, where L < 2^8
TEXT L + 2 bytes, where L < 2^16
MEDIUMTEXT L + 3 bytes, where L < 2^24
LONGTEXT L + 4 bytes, where L < 2^32
So a longtext
will use one more byte than mediumtext
to store the same text. There is a bit more information in the Data Type Storage Requirements section of the manual and some more in the The BLOB and TEXT Types section.
There’s no practical difference between the four TEXT types.