| Type | Bytes | Notes |
|---|---|---|
CHAR(M), BINARY(M) |
0 - 255 |
|
VARCHAR(M), VARBINARY(M) |
M + 1 <= 255; M + 2 > 255 |
|
TINYBLOB, TINYTEXT |
2 - 255 |
|
BLOB, TEXT |
3 - 65535 |
|
MEDIUMBLOB, MEDIUMTEXT |
4 - 16777215 |
|
LONGBLOB, LONGTEXT |
5 - 4294967295 |
|
ENUM('value1','value2',...) |
1 - 2 |
65,535 values maximum |
SET('value1','value2',...) |
1, 2, 4 or 8 |
64 values maximum |
From MySQL 5.4 Reference Manual: Data Type Storage Requirements