Data Types for MariaDB Xpand

The parent of this page is: Reference for MariaDB Xpand

Topics on this page:

Overview

A summary of data types across MariaDB Xpand versions:

Data Type	In 23.09?	In 6.1?	In 6.0?	In 5.3?
BIGINT	23.09	6.1	6.0	5.3
BINARY	23.09	6.1	6.0	5.3
BIT	23.09	6.1	6.0	5.3
BLOB	23.09	6.1	6.0	5.3
BOOL	23.09	6.1	6.0	5.3
BOOLEAN	23.09	6.1	6.0	5.3
CHAR	23.09	6.1	6.0	5.3
CHARACTER	23.09	6.1	6.0	5.3
CLOB	23.09	6.1
DATE	23.09	6.1	6.0	5.3
DATETIME	23.09	6.1	6.0	5.3
DEC	23.09	6.1	6.0	5.3
DECIMAL	23.09	6.1	6.0	5.3
DOUBLE	23.09	6.1	6.0	5.3
DOUBLE PRECISION	23.09	6.1	6.0	5.3
ENUM	23.09	6.1	6.0	5.3
FLOAT	23.09	6.1	6.0	5.3
INT	23.09	6.1	6.0	5.3
INT1	23.09	6.1	6.0	5.3
INT2	23.09	6.1	6.0	5.3
INT3	23.09	6.1	6.0	5.3
INT4	23.09	6.1	6.0	5.3
INT8	23.09	6.1	6.0	5.3
INTEGER	23.09	6.1	6.0	5.3
JSON	23.09	6.1	6.0	5.3
LONG VARBINARY	23.09
LONGBLOB	23.09	6.1	6.0	5.3
LONGTEXT	23.09	6.1	6.0	5.3
MEDIUMBLOB	23.09	6.1	6.0	5.3
MEDIUMINT	23.09	6.1	6.0	5.3
MEDIUMTEXT	23.09	6.1	6.0	5.3
NATIONAL CHAR	23.09	6.1	6.0	5.3
NATIONAL CHARACTER	23.09	6.1	6.0	5.3
NATIONAL VARCHAR	23.09
NCHAR	23.09	6.1	6.0	5.3
NUMERIC	23.09	6.1	6.0	5.3
NVARCHAR	23.09	6.1
REAL	23.09	6.1	6.0	5.3
SERIAL	23.09	6.1	6.0	5.3
SET	23.09	6.1	6.0	5.3
SMALLINT	23.09	6.1	6.0	5.3
TEXT	23.09	6.1	6.0	5.3
TIME	23.09	6.1	6.0	5.3
TIMESTAMP	23.09	6.1	6.0	5.3
TINYBLOB	23.09	6.1	6.0	5.3
TINYINT	23.09	6.1	6.0	5.3
TINYTEXT	23.09	6.1	6.0	5.3
VARBINARY	23.09	6.1	6.0	5.3
VARCHAR	23.09	6.1	6.0	5.3
YEAR	23.09	6.1	6.0	5.3