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.

Comments

Popular posts from this blog

Check MySQL query history from command line