MariaDB supports the following data types:
1. Numeric Data Types: Such as INTEGER, FLOAT, DECIMAL, etc.
1. Date and Time Data Types: Such as DATE, DATETIME, TIMESTAMP, etc.
1. String Data Types: Such as CHAR, VARCHAR, TEXT, etc.
1. Spatial Data Types: Such as GEOMETRY, POINT, LINESTRING, etc.
1. JSON Data Type: To store and manipulate JSON (JavaScript Object Notation) documents.
1. Collection data types: Such as ARRAY (only for Spider and ColumnStore) and SET.
1. Bit-value data type: BIT.
1. Binary Data types: Such as BINARY and VARBINARY.
1. ENUM dana type.
1. BLOB data type: Including TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB.
1. Time and Date types: Such as TIME, DATE, DATETIME, YEAR, TIMESTAMP.
In addition to standard SQL data types, MariaDB also provides several special-purpose data types.
