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 65,535 (64 KB)

MEDIUMTEXT(x) y+3 16,777,215 (16.7 MB)

LONGTEXT(x) y+4 4,294,967,295 (4 GB)

Datatype Size in bytes Low High Range

TINYINT (signed) 1 -128 127 256

TINYINT (unsigned) 1 0 255

SMALLINT (signed) 2 -32,768 32,767 65 thousand

SMALLINT (unsigned) 2 0 65,535

MEDIUMINT (signed) 3 -8,388,608 8,388,607 16.8 million

MEDIUMINT (unsigned) 3 0 16,777,215

INT (signed) 4 -2,147,483,648 2,147,483,647 4.3 billion

INT (unsigned) 4 0 4,294,967,295

BIGINT (signed) 8 -9,223,372,036,854,775,808 9,223,372,036,854,775,807 18.4 billion billion

BIGINT (unsigned) 8 0 18,446,744,073,709,551,615

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