Datatype Mapping Reference

9.7.0

Back Next

MySQL Source and DB2 Target

The following table identifies the recommended datatype mappings for Data Replication configurations with a MySQL source and a DB2 for Linux, UNIX, and Windows target:

MySQL Source Datatype	DB2 Target Datatype	Comments
BIGINT	DECIMAL(20,0)	-
BINARY(`n`)	BLOB(`n`)	-
BIT	DECIMAL(20,0)	-
BLOB	BLOB	-
CHAR(`n`)	CHAR(`n`)	-
DATE	DATE	-
DATETIME(`n`)	TIMESTAMP(0) Mapping condition: `n` == -1 TIMESTAMP(`n`) Mapping condition: `n` != -1	-
DECIMAL(`p`,`s`)	DECIMAL(`p'`,`s`) `p'` = 31 Mapping condition: `p` > 31 DECIMAL(`p`,`s`)	-
DOUBLE	REAL	-
ENUM	VARCHAR(255)	-
FLOAT	REAL	-
INT	BIGINT	-
LONGBLOB	BLOB	-
LONGTEXT	CLOB(1G)	-
MEDIUMBLOB	BLOB	-
MEDIUMINT	INTEGER	-
MEDIUMTEXT	CLOB(1G)	-
SET	VARCHAR(4000)	-
SMALLINT	INTEGER	-
TEXT	CLOB(1G)	-
TIME	TIME	-
TIMESTAMP(`n`)	TIMESTAMP(0) Mapping condition: `n` == -1 TIMESTAMP(`n`) Mapping condition: `n` != -1	-
TINYBLOB	BLOB(255)	-
TINYINT	SMALLINT	-
TINYTEXT	VARCHAR(255)	-
VARBINARY(`n`)	BLOB(`n`)	-
VARCHAR(`n`)	CLOB Mapping condition: `n` > 32672 VARCHAR(`n`)	-
YEAR	INTEGER	-

Rename Saved Search

Table of Contents

Datatype Mapping Reference

Datatype Mapping Reference

MySQL Source and DB2 Target

MySQL Source and DB2 Target