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 | +-----------------------+-------------+--------------------+
|
|
|
|
|
|
|