> For the complete documentation index, see [llms.txt](https://mun.gitbook.io/dbms/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mun.gitbook.io/dbms/sql/create-table/data-type.md).

# Data Type

## Character

* CHAR(size) \[255, Default 1], VARCHAR(size) \[65,535]
* TINYBLOB \[255], BLOB(size) \[65,535], MEDIUMBLOB \[16,777,215], LONGBLOB \[4,294,967,295]
  * BLOBs (Binary Large Objects). \[Unit: Byte]
* TINYTEXT \[255], TEXT(size) \[65,535], MEDIUMTEXT \[16,777,215], LONGTEXT \[4,294,967,295]
* BINARY(size) \[CHAR(), Byte, Default 1], VARBINARY(size) \[VARCHAR()]
* ENUM(val1, val2, val3, ...), SET(val1, val2, val3, ...)

## Number

* BIT(size) \[64, Default 1], BOOL \[Zero=false, nonzero=true], BOOLEAN \[BOOL]
* TINYINT(size) \[1], SMALLINT(size) \[2], MEDIUMINT(size) \[3], INT(size) \[4], INTEGER(size) \[INT(size), 4], BIGINT(size) \[8]
  * The size parameter specifies the maximum display width (which is 255)
  * Memory Unit: Byte
* FLOAT(p)
  * FLOAT(p): p is 0 to 24 for float, p is 25 to 53 for double
  * d = number of digits after the decimal point
* DOUBLE(size, d), DOUBLE PRECISION(size, d)
  * size = total number of digits (including digit before and after the decimal point)
  * d = number of digits after the decimal point
  * Memory = 64 Bit
* DECIMAL(size, d) \[max\_size=65, max\_d=30 (default d=0)], DEC(size, d) \[DECIMAL(size, d)]

## Date

* DATE \[YYYY-MM-DD] \['1000-01-01' to '9999-12-31']
* DATETIME(fsp) \[YYYY-MM-DD hh:mm:ss] \['1000-01-01 00:00:00' to '9999-12-31 23:59:59']
  * fsp (fractional seconds precision) \[fsp = 0 to 6] \[DATETIME(3) means milliseconds]
* TIMESTAMP(fsp) \[YYYY-MM-DD hh:mm:ss] \['1970-01-01 00:00:01' UTC to '2038-01-09 03:14:07']
* TIME(fsp) \[hh:mm:ss] \['-838:59:59' to '838:59:59']
* YEAR \[YYYY] \[0000, 1901 to 2155]