MySQL Manual
6 MySQL Language Reference
6.2.3 String Types
The string types are CHAR, VARCHAR, BLOB, TEXT,
ENUM, and SET. This section describes how these types work,
their storage requirements, and how to use them in your queries.
| Type | Max.size | Bytes |
TINYTEXT or TINYBLOB | 2^8-1 | 255 |
TEXT or BLOB | 2^16-1 (64K-1) | 65535 |
MEDIUMTEXT or MEDIUMBLOB | 2^24-1 (16M-1) | 16777215 |
LONGBLOB | 2^32-1 (4G-1) | 4294967295 |
Subsections
- 6.2.3.1 The
CHARandVARCHARTypes - 6.2.3.2 The
BLOBandTEXTTypes - 6.2.3.3 The
ENUMType - 6.2.3.4 The
SETType
