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

MariaDB Datatype Mapping

  • Dark
    Light
  • PDF

Article summary

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 TypeRivery Type
VARBINARYSTRING
NCHARSTRING
INTEGERINTEGER
FLOATFLOAT
DECIMALFLOAT
CHARSTRING
NUMERICFLOAT
NVARCHARSTRING
SMALLINTINTEGER
TEXTSTRING
VARCHARSTRING
BIGINTINTEGER
BINARYSTRING
TINYINTINTEGER
TIMESTAMPTIMESTAMP
REALINTEGER
DATEDATE
BITBOOLEAN
BLOBSTRING
BOOLEANBOOLEAN
DATETIMETIMESTAMP
DOUBLEFLOAT
ENUMSTRING
LONGBLOBSTRING
LONGTEXTSTRING
MEDIUMBLOBSTRING
MEDIUMINTINTEGER
MEDIUMTEXTSTRING
SETSTRING
TINYBLOBSTRING
TINYTEXTSTRING
YEARINTEGER

Was this article helpful?