Supported Datatypes

MariaDB and TileDB have slight differences in their supported datatypes. This document serves as a mapping between the (core) TileDB datatypes and the MariaDB datatypes for easy reference.
TileDB Datatype
MariaDB SQL Datatype
TILEDB_CHAR
VARCHAR
TILEDB_INT8
TINY
TILEDB_UINT8
TINY
TILEDB_INT16
SHORT
TILEDB_UINT16
SHORT
TILEDB_INT32
INTEGER
TILEDB_UINT32
LONG
TILEDB_INT64
LONG
TILEDB_UINT64
LONG
TILEDB_FLOAT32
FLOAT
TILEDB_FLOAT64
DOUBLE
TILEDB_FLOAT64
DECIMAL
TILEDB_FLOAT64
NEW DECIMAL
TILEDB_DATETIME_YEAR
YEAR
TILEDB_DATETIME_MONTH
DATE
TILEDB_DATETIME_WEEK
DATE
TILEDB_DATETIME_DAY
DATE
TILEDB_DATETIME_HR
DATETIME
TILEDB_DATETIME_MIN
DATETIME
TILEDB_DATETIME_SEC
DATETIME
TILEDB_DATETIME_MS
DATETIME
TILEDB_DATETIME_US
DATETIME
TILEDB_DATETIME_NS
DATETIME (Precision is displayed to US)
TILEDB_DATETIME_PS
DATETIME (Precision is displayed to US)
TILEDB_DATETIME_FS
DATETIME (Precision is displayed to US)
TILEDB_DATETIME_AS
DATETIME (Precision is displayed to US)

Usage

Configuration Parameters

Last modified 1yr ago

TileDB Datatype	MariaDB SQL Datatype
`TILEDB_CHAR`	`VARCHAR`
`TILEDB_INT8`	`TINY`
`TILEDB_UINT8`	`TINY`
`TILEDB_INT16`	`SHORT`
`TILEDB_UINT16`	`SHORT`
`TILEDB_INT32`	`INTEGER`
`TILEDB_UINT32`	`LONG`
`TILEDB_INT64`	`LONG`
`TILEDB_UINT64`	`LONG`
`TILEDB_FLOAT32`	`FLOAT`
`TILEDB_FLOAT64`	`DOUBLE`
`TILEDB_FLOAT64`	`DECIMAL`
`TILEDB_FLOAT64`	`NEW DECIMAL`
`TILEDB_DATETIME_YEAR`	`YEAR`
`TILEDB_DATETIME_MONTH`	`DATE`
`TILEDB_DATETIME_WEEK`	`DATE`
`TILEDB_DATETIME_DAY`	`DATE`
`TILEDB_DATETIME_HR`	`DATETIME`
`TILEDB_DATETIME_MIN`	`DATETIME`
`TILEDB_DATETIME_SEC`	`DATETIME`
`TILEDB_DATETIME_MS`	`DATETIME`
`TILEDB_DATETIME_US`	`DATETIME`
`TILEDB_DATETIME_NS`	`DATETIME` (Precision is displayed to US)
`TILEDB_DATETIME_PS`	`DATETIME` (Precision is displayed to US)
`TILEDB_DATETIME_FS`	`DATETIME` (Precision is displayed to US)
`TILEDB_DATETIME_AS`	`DATETIME` (Precision is displayed to US)