MySQL Datatypes

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