2
String Data Types
-
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. -
CHAR VARYING
Overview See VARCHAR. EXAMPLES CREATE TABLE char_varying_example ( examp... -
CHARACTER
Overview See CHAR. EXAMPLES CREATE TABLE character_example ( example CHA... -
CHARACTER VARYING
Overview See VARCHAR. EXAMPLES CREATE TABLE character_varying_example ( ... -
CLOB
Overview See LONGTEXT. EXAMPLES SET sql_mode='oracle'; CREATE TABLE clob_... -
LONG
Overview See MEDIUMTEXT. EXAMPLES CREATE TABLE long_example ( example LONG ); SHOW CREAT -
LONG CHAR VARYING
Overview See MEDIUMTEXT. EXAMPLES CREATE TABLE long_char_varying_example ... -
LONG CHARACTER VARYING
Overview See MEDIUMTEXT. EXAMPLES CREATE TABLE long_character_varying_exam... -
LONG VARBINARY
Overview See MEDIUMBLOB. EXAMPLES CREATE TABLE long_varbinary_example ( ... -
LONG VARCHAR
Overview See MEDIUMTEXT. EXAMPLES CREATE TABLE long_varchar_example ( e... -
LONG VARCHARACTER
Overview See MEDIUMTEXT. EXAMPLES CREATE TABLE long_varcharacter_example (... -
NATIONAL CHAR
Overview Fixed-length string of specific character set with limit up to 25... -
NATIONAL CHAR VARYING
Overview See NATIONAL VARCHAR. EXAMPLES CREATE TABLE national_char_varying... -
NATIONAL CHARACTER
Overview See NATIONAL CHAR. EXAMPLES CREATE TABLE national_character_examp... -
NATIONAL CHARACTER VARYING
Overview See NATIONAL VARCHAR. EXAMPLES CREATE TABLE national_character_va... -
NATIONAL VARCHAR
Overview Variable-length string of specific character set with limit up to... -
NATIONAL VARCHARACTER
Overview See NATIONAL VARCHAR. EXAMPLES CREATE TABLE national_varcharacter... -
NCHAR
Overview See NATIONAL VARCHAR. EXAMPLES CREATE TABLE nchar_example ( exa... -
NCHAR VARCHAR
Overview See NATIONAL VARCHAR. EXAMPLES CREATE TABLE nchar_varchar_example... -
NCHAR VARCHARACTER
Overview See NATIONAL VARCHAR. EXAMPLES CREATE TABLE nchar_varcharacter_ex... -
NCHAR VARYING
Overview See NATIONAL VARCHAR. EXAMPLES CREATE TABLE nchar_varying_example... -
RAW
Overview See VARBINARY. EXAMPLES SET sql_mode='oracle'; CREATE TABLE raw_e... -
VARCHAR2
Overview See VARCHAR. EXAMPLES SET sql_mode='oracle'; CREATE TABLE varcha... -
VARCHARACTER
Overview See VARCHAR. EXAMPLES CREATE TABLE varcharacter_example ( examp...
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.
