Tinytext、 TEXT、 MEDIUMTEXT 和 LONGTEXT 的最大存储大小

Question

Per the MySQL docs, there are four TEXT types:

1. TINYTEXT
2. TEXT
3. MEDIUMTEXT
4. LONGTEXT

What is the maximum length that I can store in a column of each data type assuming the character encoding is UTF-8?

转载于:https://stackoverflow.com/questions/13932750/tinytext-text-mediumtext-and-longtext-maximum-storage-sizes

Answer 1

From the documentation :

      Type | Maximum length
-----------+-------------------------------------
  TINYTEXT |           255 (2 8−1) bytes
      TEXT |        65,535 (216−1) bytes = 64 KiB
MEDIUMTEXT |    16,777,215 (224−1) bytes = 16 MiB
  LONGTEXT | 4,294,967,295 (232−1) bytes =  4 GiB

Note that the number of characters that can be stored in your column will depend on the character encoding.