Mapping Between MySQL and GaussDB(DWS) Field Types

DataArts Migration converts the source field type to the destination field type based on the default rule, and creates tables and synchronizes data in real time.

Field Type Mapping Rules

The following table lists the field types supported by a job that migrates data from MySQL to GaussDB(DWS).

**Table 1** Field types supported by a job that migrates data from MySQL to GaussDB(DWS)
Type	MySQL Data Type	GaussDB(DWS) Data Type	Description
String	CHAR(M)	CHAR(4M)	N/A
String	VARCHAR(M)	VARCHAR(4M)	N/A
Value	BOOLEAN	BOOL	N/A
	TINYINT	SMALLINT	By default, TINYINT(1) is converted to BOOLEAN. If you want to keep it as TINYINT(1), add the following attribute to the MySQL data connection in Management Center: tinyInt1isBit = false
	TINYINT UNSIGNED	SMALLINT	N/A
	SMALLINT	SMALLINT	N/A
	SMALLINT UNSIGNED	INTEGER	N/A
	MEDIUMINT	INTEGER	N/A
	MEDIUMINT UNSIGNED	INTEGER	N/A
	INT	INTEGER	N/A
	INT UNSIGNED	BIGINT	N/A
	BIGINT	BIGINT	N/A
	BIGINT UNSIGNED	NUMERIC(38)	N/A
	REAL	FLOAT8	N/A
	DECIMAL(M,D)	DECIMAL(M,D)	N/A
	NUMBERIC	NUMBERIC(M,D)	N/A
	FLOAT(M,D)	FLOAT4	N/A
	DOUBLE(M,D)	FLOAT8	N/A
	DOUBLE PRECISION	FLOAT8	N/A
Bit	BIT(M)	BOOL	N/A
Time and date	DATE	TIMESTAMP(0)	N/A
	TIME	TIME	N/A
	DATETIME	TIMESTAMP	N/A
	TIMESTAMP	TIMESATMPTZ	N/A
	YEAR(M)	VARCHAR(15)	N/A
Media (binary)	BINARY(M)	BYTEA	N/A
	VARBINARY(M)	BYTEA	N/A
	TEXT	TEXT	N/A
	TINYTEXT	TEXT	N/A
	MEDIUMTEXT	TEXT	N/A
	LONGTEXT	TEXT	N/A
Special type	SET	VARCHAR	N/A
	JSON	JSON	N/A
	ENUM	VARCHAR	N/A