MySQL->GaussDB

**Table 1** Data type mapping
Data Type (MySQL)	Data Type (GaussDB)	Whether to Support Mapping
CHAR	CHARACTER	Yes. If a column of this type in the source database contains characters that occupy more than one byte, increase the length of the column in the destination database.
VARCHAR	CHARACTER VARYING()	Yes. If a column of this type in the source database contains characters that occupy more than one byte, increase the length of the column in the destination database.
BINARY	BYTEA	Yes
VARBINARY	BYTEA	Yes
TINYBLOB	BYTEA	Yes
BLOB	BYTEA	Yes
MEDIUMBLOB	BYTEA	Yes
LONGBLOB	BYTEA	Yes
TINYTEXT	TEXT	Yes
TEXT	TEXT	Yes
MEDIUMTEXT	TEXT	Yes
LONGTEXT	TEXT	Yes
ENUM	VARCHAR	Yes
SET	VARCHAR	Yes
TINYINT	SMALLINT	Yes
SMALLINT	SMALLINT	Yes
MEDIUMINT	INT	Yes
INT	INT	Yes
BIGINT	BIGINT	Yes
FLOAT	REAL/DOUBLE PRECISION	Yes
DOUBLE	DOUBLE PRECISION	Yes
DATE	DATE	Yes
DATETIME	TIMESTAMP WITHOUT TIME ZONE	Yes
TIMESTAMP	TIMESTAMP WITH TIME ZONE	Yes
TIME	TIME WITHOUT TIME ZONE	Yes
BIT	BIT	Yes
JSON	JSON	Yes, but JSON containing BIT data is not supported.
DECIMAL	NUMERIC	Yes
NUMERIC	NUMERIC	Yes

DATE values supported by MySQL range from '1000-01-01' to '9999-12-31'.
DATETIME values supported by MySQL range from '1000-01-01 00:00:00' to '9999-12-31 23:59:59'.

TIMESTAMP values supported by MySQL range from '1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07' UTC.

For details, see official MySQL documentation.

For GaussDB, 0000-00-00 is an invalid date and will be converted to 1970-01-01 by DRS. For example, '0000-00-00' of the DATE type in MySQL is converted to '1970-01-01' by DRS, and '1000-00-31 23:59:59' of the DATETIME or TIMESTAMP type in MySQL is converted to '1970-01-01 00:00:00' by DRS.
TIME values supported by MySQL range from '-838:59:59' to '838:59:59'. For details, see the official MySQL documentation. For GaussDB, the minimum value of the TIME type is 00:00:00 and the maximum value is 24:00:00. In MySQL, if a value of the TIME type is less than 00:00:00 or greater than 24:00:00, DRS will convert it to 00:00:00.
YEAR value ranges supported by MySQL are 1901 to 2155 and 0000. For details, see official MySQL documentation. GaussDB does not have the YEAR type, so DRS will convert the YEAR type of MySQL to the SMALLINT type.
For MySQL databases, '0000' of the DATE type will be converted to 0 by DRS.
If the data type of a column is INT and the column contains the AUTO_INCREMENT attribute, DRS converts the data type of the column to SERIAL during synchronization.