Data Types for MariaDB Xpand

Overview

MariaDB Xpand supports many data types.

Compatibility

  • MariaDB Xpand 5.3

  • MariaDB Xpand 6

Supported Data Types

Data Types supported by Xpand include:

  • BIGINT

  • BINARY

  • BIT

  • BLOB

  • BOOL

  • CHAR

  • 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

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

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

  • When creating a column of type bit(0), MySQL will automatically create a bit(1). Xpand will not allow you to create a column with type bit(0) and will provide an error message.