Data Types

Data Types in MariaDB

Title	Description

Numeric Data Types

Title	Description
Numeric Data Type Overview	Overview and usage of the numeric data types.
TINYINT	Tiny integer, -128 to 127 signed.
BOOLEAN	Synonym for TINYINT(1).
SMALLINT	Small integer from -32768 to 32767 signed.
MEDIUMINT	Medium integer from -8388608 to 8388607 signed.
INT	Integer from -2147483648 to 2147483647 signed.
INTEGER	Synonym for INT
BIGINT	Large integer.
DECIMAL	A packed "exact" fixed-point number.
DEC, NUMERIC, FIXED	Synonyms for DECIMAL
NUMBER	Synonym for DECIMAL in Oracle mode.
FLOAT	Single-precision floating-point number
DOUBLE	Normal-size (double-precision) floating-point number
DOUBLE PRECISION	REAL and DOUBLE PRECISION are synonyms for DOUBLE.
BIT	Bit field type.
Floating-point Accuracy	Not all floating-point numbers can be stored with exact precision
INT1	A synonym for TINYINT.
INT2	Synonym for SMALLINT.
INT3	Synonym for MEDIUMINT.
INT4	Synonym for INT.
INT8	Synonym for BIGINT.

String Data Types

Title	Description
String Literals	Strings are sequences of characters and are enclosed with quotes.
BINARY	Fixed-length binary byte string.
BLOB	Binary large object up to 65,535 bytes.
BLOB and TEXT Data Types	Binary large object data types and the corresponding TEXT types.
CHAR	Fixed-length string.
CHAR BYTE	Alias for BINARY.
ENUM	Enumeration, or string object that can have one value chosen from a list of values.
INET6	For storage of IPv6 addresses.
JSON Data Type	Compatibility data type that is an alias for LONGTEXT.
MEDIUMBLOB	Medium binary large object up to 16,777,215 bytes.
MEDIUMTEXT	A TEXT column with a maximum length of 16,777,215 characters.
LONGBLOB	Long BLOB holding up to 4GB.
LONG and LONG VARCHAR	LONG and LONG VARCHAR are synonyms for MEDIUMTEXT.
LONGTEXT	A TEXT column with a maximum length of 4,294,967,295 characters.
ROW	Data type for stored procedure variables.
TEXT	A TEXT column with a maximum length of 65,535 characters.
TINYBLOB	Tiny binary large object up to 255 bytes.
TINYTEXT	A TEXT column with a maximum length of 255 characters.
VARBINARY	Variable-length binary byte string.
VARCHAR	Variable-length string.
SET Data Type	Set, or string object that can have 0 or more values chosen from a list of values.
UUID Data Type	Data type intended for the storage of UUID data.
Data Type Storage Requirements	Storage requirements for the various data types.
Supported Character Sets and Collations	MariaDB supports the following character sets and collations.
Character Sets and Collations	Setting character set and collation for a language.

Date and Time Data Types

Title	Description
DATE	The date type YYYY-MM-DD.
TIME	Time format HH:MM:SS.ssssss
DATETIME	Date and time combination displayed as YYYY-MM-DD HH:MM:SS.
TIMESTAMP	YYYY-MM-DD HH:MM:SS
YEAR Data Type	A four-digit year.
Future developments for temporal types	My current project is a forecasting application with dates going out to 263...
How to define a date in order to import an empty date from a CSV file?	I have a CSV file containing amongst other things a couple of date columns....
Which datatypes are supported by MariaDB	I would like to know which datatypes are supported by MariaDB. I'm asking s...

Title	Description
Geometry Types	Supported geometry types
AUTO_INCREMENT	Automatic increment.
Data Type Storage Requirements	Storage requirements for the various data types.
AUTO_INCREMENT FAQ	Frequently-asked questions about auto_increment.
NULL Values	NULL represents an unknown value.

Data Types

Numeric Data Types

String Data Types

Date and Time Data Types

Other Data Types Articles