MySQL datatype mapping

While extracting your data, the process matches MySQL data types with Data Integration data types and maps any unsupported types as String. The mapping of MySQL data types to Data Integration-compatible types:

MySQL type	Data Integration type	Remarks
INT	INTEGER	-
BIGINT	INTEGER	-
DATETIME	TIMESTAMP	-
FLOAT	FLOAT	-
TINYINT	INTEGER	-
SMALLINT	INTEGER	-
CHAR	STRING	-
VARCHAR	STRING	-
LONGVARCHAR	STRING	-
TEXT	STRING	-
LONGTEXT	STRING	-
DATE	DATE	-
BOOL	BOOLEAN	-
TIME	DATETIME	-
TIMESTAMP	TIMESTAMP	-
YEAR	INTEGER	-
BIT	BOOLEAN	-
JSON	STRING	-
LONGBLOB	STRING	-
NUMERIC	FLOAT	-
DECIMAL	FLOAT	-
NCHAR	STRING	-
DOUBLE	FLOAT	-
REAL	FLOAT	-
VARBINARY	STRING	-
BINARY	STRING	-
MEDIUMBLOB	STRING	-
MEDIUMINT	INTEGER	-
ENUM	STRING	-
SET	STRING	-
GEOMETRY	STRING	The GEOMETRY data type is displayed in the form of WKT
GEOMETRYCOLLECTION	STRING	A binary string that represents a value
LINESTRING	STRING	A binary string that represents a value
MULTILINESTRING	STRING	A binary string that represents a value
MULTIPOINT	STRING	A binary string that represents a value
MULTIPOLYGON	STRING	A binary string that represents a value
POLYGON	STRING	A binary string that represents a value
POINT	STRING	A binary string that represents a value