Data Types in MariaDB
Numeric Data Types
-
TINYINT
Syntax: TINYINT[(M)] [UNSIGNED] [ZEROFILL]Description: A very small integer... -
BOOLEAN
Syntax: BOOL, BOOLEANDescription: These types are synonyms for TINYINT(1). ... -
SMALLINT
Syntax: SMALLINT[(M)] [UNSIGNED] [ZEROFILL]Description: A small integer. Th... -
MEDIUMINT
Syntax: MEDIUMINT[(M)] [UNSIGNED] [ZEROFILL]Description: A medium-sized int... -
INT
Syntax: INT[(M)] [UNSIGNED] [ZEROFILL]Description: A normal-size integer. W... -
INTEGER
Syntax: INTEGER[(M)] [UNSIGNED] [ZEROFILL] Description: This type is a synonym for INT. -
BIGINT
Syntax: BIGINT[(M)] [UNSIGNED] [ZEROFILL]Description: A large integer. The ... -
DECIMAL
Syntax: DECIMAL[(M[,D])] [UNSIGNED] [ZEROFILL]Description: A packed "exact"... -
DEC, NUMERIC, FIXED
Syntax: DEC[(M[,D])] [UNSIGNED] [ZEROFILL] NUMERIC[(M[,D])] [UNSIGNED] [ZE... -
FLOAT
Syntax: FLOAT[(M,D)] [UNSIGNED] [ZEROFILL]Description: A small (single-prec... -
DOUBLE
Syntax: DOUBLE[(M,D)] [UNSIGNED] [ZEROFILL]Description: A normal-size (doub... -
DOUBLE PRECISION
Syntax: DOUBLE PRECISION[(M,D)] [UNSIGNED] [ZEROFILL], REAL[(M,D)] [UNSIGNE... -
BIT
Syntax: BIT[(M)]Description: A bit-field type. M indicates the number of bi...
String Data Types
-
CHAR
Syntax: [NATIONAL] CHAR[(M)] [CHARACTER SET charset_name] [COLLATE collatio... -
VARCHAR
Syntax: [NATIONAL] VARCHAR(M) [CHARACTER SET charset_name] [COLLATE collati... -
BINARY
Syntax: BINARY(M)Description: The BINARY type is similar to the CHAR type, ... -
CHAR BYTE
Description: The CHAR BYTE data type is an alias for the BINARY data type.... -
VARBINARY
Syntax: VARBINARY(M)Description: The VARBINARY type is similar to the VARC... -
TINYBLOB
Syntax: TINYBLOBDescription: A BLOB column with a maximum length of 255 (2... -
BLOB
Syntax: BLOB[(M)]Description: A BLOB column with a maximum length of 65,535... -
BLOB DATA TYPE
Description: A BLOB is a binary large object that can hold a variable amoun... -
MEDIUMBLOB
Syntax: MEDIUMBLOBDescription: A BLOB column with a maximum length of 16,77... -
LONGBLOB
Syntax: LONGBLOBDescription: A BLOB column with a maximum length of 4,294,... -
TINYTEXT
Syntax: TINYTEXT [CHARACTER SET charset_name] [COLLATE collation_name]Descr... -
TEXT
Syntax: TEXT[(M)] [CHARACTER SET charset_name] [COLLATE collation_name]Desc... -
MEDIUMTEXT
Syntax: MEDIUMTEXT [CHARACTER SET charset_name] [COLLATE collation_name]Des... -
LONGTEXT
Syntax: LONGTEXT [CHARACTER SET charset_name] [COLLATE collation_name]Descr... -
ENUM
Syntax: ENUM('value1','value2',...) [CHARACTER SET charset_name] [COLLATE c... -
SET Data Type
Syntax: SET('value1','value2',...) [CHARACTER SET charset_name] [COLLATE co... -
Supported Character Sets and Collations
MariaDB supports the following Character Sets: MariaDB [(none)]> SHOW CHARACTER SET; +----- -
Character Sets and Collations
Simply put, a character set defines how and which characters are stored to ...
Date and Time Data Types
-
DATE
Syntax: DATEDescription: A date. The supported range is '1000-01-01' to '99... -
TIME
Syntax: TIME [(<microsecond precision>)]Microsecond precision can be from 0... -
DATETIME
Syntax: DATETIME [(microsecond precision)]Microsecond precision can be from... -
TIMESTAMP
Syntax: TIMESTAMP [(<microsecond precision)]Microsecond precision can be fr... -
YEAR Data Type
Syntax: YEAR[(2|4)]Description: A year in two-digit or four-digit format. T...
