From MariaDB to GaussDB

Source Data Type	Converted Data Type	Conversion Configuration
TINYINT	TINYINT/SMALLINT	CHECK constraint for some numeric types ZEROFILL for numeric types
INT1	SMALLINT	CHECK constraint for some numeric types
SMALLINT	SMALLINT/MEDIUMINT	CHECK constraint for some numeric types ZEROFILL for numeric types
INT2	INT2	-
MEDIUMINT	MEDIUMINT	CHECK constraint for some numeric types ZEROFILL for numeric types
IN3	MEDIUMINT	-
INT/INTEGER	INT/BIGINT	CHECK constraint for some numeric types ZEROFILL for numeric types
INT4	INT4	-
BIGINT	BIGINT	CHECK constraint for some numeric types ZEROFILL for numeric types
INT8	INT8	-
SERIAL	SERIAL/BIGSERIAL/LARGESERIAL	SERIAL data type NOT NULL and UNIQUE constraints for SERIAL
BOOL/BOOLEAN	SMALLINT	CHECK constraint for some numeric types
DECIMAL/DEC/NUMERIC/FIXED	DECIMAL	CHECK constraint for some numeric types ZEROFILL for numeric types
NUMBER	DECIMAL	CHECK constraint for some numeric types ZEROFILL for numeric types DOUBLE and NUMBER (without specifying precision and scale) data types
FLOAT	FLOAT4/DOUBLE PRECISION	CHECK constraint for some numeric types ZEROFILL for numeric types FLOAT data type
DOUBLE/DOUBLE PRECISION/REAL	NUMERIC/DOUBLE PRECISION	CHECK constraint for some numeric types ZEROFILL for numeric types DOUBLE and NUMBER (without specifying precision and scale) data types
CHAR/NCHAR	CHAR	CHAR data type
VARCHAR/NVARCHAR	VARCHAR	VARCHAR data type
BIT	Error	-
BINARY/CHAR BYTE/VARBINARY/RAW	BYTEA	BINARY, CHAR BYTE, VARBINARY, and RAW data types
TINYBLOB/MEDIUMBLOB/LONGBLOB/LONG VARBINARY	BYTEA/BLOB	TINYBLOB, MEDIUMBLOB, and LONGBLOB data types
BLOB	BYTEA/BLOB	BLOB data type
TINYTEXT/MEDIUMTEXT	TEXT/VARCHAR	TINYTEXT and MEDIUMTEXT data types
TEXT	TEXT/VARCHAR	TEXT data type
LONGTEXT/JSON/CLOB	TEXT/CLOB	LONGTEXT, JSON, and CLOB data types
DATE	TIMESTAMP	-
TIME	TIME	-
DATETIME	TIMESTAMP	-
TIMESTAMP	TIMESTAMP WITH TIME ZONE	-
YEAR	VARCHAR/SMALLINT	YEAR Data Type
INET4/INET6	INET	INET4 and INET6 data types
UUID	UUID	-
ENUM	VARCHAR	ENUM data type
SET	VARCHAR	SET data type