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. |
| 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. |
| INET4 |
For storage of IPv4 addresses. |
| 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. |
Other Data Types Articles
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.