| Datatype | Storage for y bytes | Maximum Size | |
| CHAR(x) | x | 255 | |
| VARCHAR(x) | y+1 | 255 | |
| TINYTEXT(x) | y+1 | 255 | |
| TEXT(x) | y+2 | 65535 | (64 KB) |
| MEDIUMTEXT(x) | y+3 | 16777215 | (16.7 MB) |
| LONGTEXT(x) | y+4 | 4294967295 | (4 GB) |
| Datatype | Size in bytes | Low | High | Range |
| TINYINT (signed) | 1 | -128 | 127 | |
| TINYINT (unsigned) | 1 | 0 | 255 | |
| SMALLINT (signed) | 2 | -32768 | 32767 | |
| SMALLINT (unsigned) | 2 | 0 | 65535 | 65 thousand |
| MEDIUMINT (signed) | 3 | -8388608 | 8388607 | |
| MEDIUMINT (unsigned) | 3 | 0 | 16777215 | 16.8 million |
| INT (signed) | 4 | -2147483648 | 2147483647 | |
| INT (unsigned) | 4 | 0 | 4294967295 | 4.3 billion |
| BIGINT (signed) | 8 | -9223372036854775808 | 9223372036854775807 | |
| BIGINT (unsigned) | 8 | 0 | 18446744073709551615 | 18.4 billion billion |
| Datatype | Size in bytes | Maximum Value | Minimum Value |
| FLOAT | 4 | +/- 3.402823466 e38 | +/- 1.175494351 e-38 |
| DOUBLE | 8 | +/- 1.7976931348623157 e308 | +/- 2.2250738585072014 e-308 |
| Datatype | Size in bytes | Minimum Value | Maximum Value |
| DATETIME | 8 | 1000-01-01 00:00:00 | 9999-12-31 23:59:59 |
| DATE | 3 | 1000-01-01 | 9999-12-31 |
| TIMESTAMP | 4 | ? | ? |
| TIME | 3 | -838:59:59 | 838:59:59 |
| YEAR | 1 | 1901 | 2155 |