db/sql/ ColumnTypes

See https://mariadb.com/kb/en/data-types/

Numeric Data Types

TINYINT Tiny integer, -128 to 127 signed.
BOOLEAN Synonym for TINYINT(1).
SMALLINT Small integer from -32768 to 32767 signed.
MEDIUMINT Medium integer from -8388608 to 8388607 signed.
INT Integer from -2147483648 to 2147483647 signed.
INTEGER Synonym for INT
BIGINT Large integer.
DECIMAL A packed "exact" fixed-point number.
DEC, NUMERIC, FIXED Synonyms for DECIMAL
NUMBER Synonym for DECIMAL in Oracle mode.
FLOAT Single-precision floating-point number
DOUBLE Normal-size (double-precision) floating-point number
DOUBLE PRECISION REAL and DOUBLE PRECISION are synonyms for DOUBLE.
BIT Bit field type.
INT1 A synonym for TINYINT.
INT2 Synonym for SMALLINT.
INT3 Synonym for MEDIUMINT.
INT4 Synonym for INT.
INT8 Synonym for BIGINT.

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

Date and Time Data Types

DATE The date type YYYY-MM-DD.
TIME Time format HH:MM:SS.ssssss
DATETIME Date and time combination displayed as YYYY-MM-DD HH:MM:SS.
TIMESTAMP YYYY-MM-DD HH:MM:SS
YEAR Data Type A four-digit year.