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

MySQL Datatype Mapping

  • Dark
    Light
  • PDF

Article Summary

While extracting your data, we match MySQL data types to Rivery data types. If a data type isn't supported, we will automatically map it as a String type.

The mapping of MySQL data types to Rivery-compatible types is shown in the table below:

MySQL TypeRivery TypeRemarks
INTINTEGER-
BIGINTINTEGER-
DATETIMETIMESTAMP-
FLOATFLOAT-
TINYINTINTEGER-
SMALLINTINTEGER-
BIGINTINTEGER-
CHARSTRING-
VARCHARSTRING-
LONGVARCHARSTRING-
TEXTSTRING-
LONGTEXTSTRING-
DATEDATE-
BOOLBOOLEAN-
TIMEDATETIME-
TIMESTAMPTIMESTAMP-
YEARINTEGER-
BITBOOLEAN-
JSONSTRING-
LONGBLOBSTRING-
NUMERICFLOAT-
DECIMALFLOAT-
NCHARSTRING-
DOUBLEFLOAT-
REALFLOAT-
VARBINARYSTRING-
BINARYSTRING-
MEDIUMBLOBSTRING-
MEDIUMINTINTEGER-
ENUMSTRING-
SETSTRING-
GEOMETRYSTRINGThe GEOMETRY data type will be displayed in the form of a Well-Known Text (WKT)
GEOMETRYCOLLECTIONSTRINGA binary string that represents a value
LINESTRINGSTRINGA binary string that represents a value
MULTILINESTRINGSTRINGA binary string that represents a value
MULTIPOINTSTRINGA binary string that represents a value
MULTIPOLYGONSTRINGA binary string that represents a value
PLOYGONSTRINGA binary string that represents a value
POINTSTRINGA binary string that represents a value

Was this article helpful?