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