SQL/MySQL/Data Type/Text Type

Материал из SQL эксперт
Перейти к: навигация, поиск

TEXT and BLOB Data Type Sizes and Upper Limits (in Bytes)

+-----------------------+-------------+--------------------+ 
Data Type               |  Size       |  Bytes             |
+--------------------------+----------+--------------------+ 
|TINYTEXT and TINYBLOB  | 2^8-1       |255                 |
+-----------------------+-------------+--------------------+ 
| TEXT and BLOB         |2^16-1       |65,535              |
+-----------------------+-------------+--------------------+ 
|MEDIUMTEXT and         |2^24-1       | 16,777,215         |
|MEDIUMBLOB             |             |                    |
+-----------------------+-------------+--------------------+ 
|LONGTEXT and LONGBLOB  |2^32-1       | 4,294,967,295      |
+-----------------------+-------------+--------------------+