Oct 22, 2018

What is the maximum storage sizes of TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT in mysql

      Type | Maximum length
-----------+-------------------------------------
  TINYTEXT |           255 (2 8−1) bytes
      TEXT |        65,535 (216−1) bytes = 64 KB
MEDIUMTEXT |    16,777,215 (224−1) bytes = 16 MB
  LONGTEXT | 4,294,967,295 (232−1) bytes =  4 GB
Note that the number of characters that can be stored in your column will depend on the character encoding.