CHAR(M ) |
M × w bytes, 0 <= M <= 255, where w is the number of bytes required for the maximum-length character in the character set |
BINARY(M ) |
M bytes, 0 <= M <= 255 |
VARCHAR(M ) , VARBINARY(M ) |
L + 1 bytes if column values require 0 – 255 bytes, L + 2 bytes if values may require more than 255 bytes |
TINYBLOB , TINYTEXT |
L + 1 bytes, where L < 28 |
BLOB , TEXT |
L + 2 bytes, where L < 216 |
MEDIUMBLOB , MEDIUMTEXT |
L + 3 bytes, where L < 224 |
LONGBLOB , LONGTEXT |
L + 4 bytes, where L < 232 |
ENUM('value1 ','value2 ',...) |
1 or 2 bytes, depending on the number of enumeration values (65,535 values maximum) |
SET('value1 ','value2 ',...) |
1, 2, 3, 4, or 8 bytes, depending on the number of set members (64 members maximum) |