-
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
...
