Data Types for MariaDB Xpand

Overview

MariaDB Xpand supports many data types.

Compatibility

  • MariaDB Xpand 5.3

  • MariaDB Xpand 6.0

  • MariaDB Xpand 6.1

Supported Data Types

Data Types supported by Xpand include:

  • BIGINT

  • BINARY

  • BIT

  • BLOB

  • BOOL

  • CHAR

  • CLOB (starting with Xpand 6.1)

  • DATE and DATETIME including Fractional Seconds

  • DECIMAL (M,D)

  • DOUBLE (M,D)

  • DOUBLE PRECISION (M,D) (is treated as DOUBLE)

  • ENUM ("A")

  • FLOAT (M,D)

  • INT

  • JSON

  • LONGBLOB

  • LONGTEXT

  • MEDIUMBLOB

  • MEDIUMINT

  • MEDIUMTEXT

  • NATIONAL VARCHAR (starting with Xpand 6.1)

  • NUMERIC (M,D) (is treated as DECIMAL)

  • NVARCHAR (starting with Xpand 6.1)

  • REAL (is treated as DOUBLE)

  • SERIAL (is treated as BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT)

  • SET ("A","B") SMALLINT TEXT TIME TIMESTAMP

  • SMALLINT

  • TEXT

  • TIME

  • TINYBLOB

  • TINYINT

  • TINYTEXT

  • VARBINARY

  • VARCHAR

  • YEAR

The full list of supported data types for MariaDB Xpand are available in reference. For additional information, see "Data Type Reference for MariaDB Xpand".

Unsupported Data Types

Xpand does not support:

  • Spatial Extensions

Caveats for Data Type Support

  • Xpand permits table definitions that use the VARCHAR data type with no max length, and supply a default max length of 21845. MySQL does not permit this.