MariaDB datatype mapping

You can match MariaDB data types to Data Integration data types while extracting your data. If a data type is not supported, it is mapped as a String type.

The table shows the mapping of MariaDB data types to Data Integration-compatible types:

MariaDB type	Data Integration 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