String Data Types
-
String Literals
Strings are sequences of characters and are enclosed with quotes. -
CHAR
Fixed-length string. -
VARCHAR
Variable-length string. -
BINARY
Fixed-length binary byte string. -
CHAR BYTE
Alias for BINARY. -
VARBINARY
Variable-length binary byte string. -
TINYBLOB
Tiny binary large object up to 255 bytes. -
BLOB
Binary large object up to 65,535 bytes. -
BLOB and TEXT Data Types
Binary large object data types and the corresponding TEXT types. -
MEDIUMBLOB
Medium binary large object up to 16,777,215 bytes. -
LONGBLOB
Long BLOB holding up to 4GB. -
TINYTEXT
A TEXT column with a maximum length of 255 characters. -
TEXT
A TEXT column with a maximum length of 65,535 characters. -
MEDIUMTEXT
A TEXT column with a maximum length of 16,777,215 characters. -
LONGTEXT
A TEXT column with a maximum length of 4,294,967,295 characters. -
INET6
For storage of IPv6 addresses. -
JSON Data Type
Compatibility data type that is an alias for LONGTEXT. -
ENUM
Enumeration, or string object that can have one value chosen from a list of values. -
SET Data Type
Set, or string object that can have 0 or more values chosen from a list of values. -
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. -
Data Type Storage Requirements
Storage requirements for the various data types. -
ROW
Data type for stored procedure variables.
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.
