Title | Description |
---|---|
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. |
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. |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/string-data-types/