Datatype Mapping Reference

Back Next

MySQL Source and MySQL Target

The following table identifies the recommended datatype mappings for Data Replication configurations with a MySQL source and a MySQL target:

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