MariaDB Datatype Mapping
  • 1 Minute to read
  • Dark
    Light
  • PDF

MariaDB Datatype Mapping

  • Dark
    Light
  • PDF

We match MariaDB data types to Rivery data types while extracting your data. If a data type is not supported, we will map it as a String type.

The following table shows the mapping of MariaDB data types to Rivery-compatible types:

MariaDB Type Rivery Type
VARBINARY STRING
NCHAR STRING
INTEGER INTEGER
FLOAT FLOAT
DECIMAL FLOAT
CHAR STRING
NUMERIC FLOAT
NVARCHAR STRING
SMALLINT INTEGER
TEXT STRING
VARCHAR STRING
BIGINT INTEGER
BINARY STRING
TINYINT INTEGER
TIMESTAMP TIMESTAMP
REAL INTEGER
DATE DATE
BIT BOOLEAN
BLOB STRING
BOOLEAN BOOLEAN
DATETIME TIMESTAMP
DOUBLE FLOAT
ENUM STRING
LONGBLOB STRING
LONGTEXT STRING
MEDIUMBLOB STRING
MEDIUMINT INTEGER
MEDIUMTEXT STRING
SET STRING
TINYBLOB STRING
TINYTEXT STRING
YEAR INTEGER

Was this article helpful?