Updated on 2024-11-07 GMT+08:00

From MySQL to GaussDB

Source Data Type

Converted Data Type (Versions Earlier Than GaussDB 8.0)

Converted Data Type (GaussDB 8.0 and Later Versions)

Conversion Configuration

CHAR

CHAR

CHAR

Character set length conversion

If you select This config will extend the character data type length, the storage of characters converted by DRS and UGO is equivalent.

VARCHAR

VARCHAR

VARCHAR

Character set length conversion.

If you select This config will extend the character data type length, the storage of characters converted by DRS and UGO is equivalent.

BINARY

BYTEA

BYTEA

-

VARBINARY

BYTEA

BYTEA

-

TINYBLOB

BYTEA

TINYBLOB

-

BLOB

BLOB

BLOB

BLOB

If you select BLOB data type will retain, the storage of characters converted by DRS and UGO is equivalent.

MEDIUMBLOB

BYTEA

MEDIUMBLOB

-

LONGBLOB

BYTEA

LONGBLOB

LONGBLOB

If you select LONGBLOB will convert to BYTEA, the storage of characters converted by DRS and UGO is equivalent.

TINYTEXT

TEXT

TINYTEXT

-

TEXT

TEXT

TEXT

TEXT datatype conversion

If you select Not conversion, retain the text data type, and comment out the length, the storage of characters converted by DRS and UGO is equivalent.

MEDIUMTEXT

TEXT

MEDIUMTEXT

-

LONGTEXT

CLOB

LONGTEXT

LONGTEXT

If you select This config will convert LONGTEXT to CLOB, the storage of characters converted by DRS and UGO is equivalent.

ENUM

VARCHAR

VARCHAR

-

SET

SET

SET

-

TINYINT

SMALLINT

TINYINT

TINYINT

If you select This data type will be converted to TINYINT., the storage of characters converted by DRS and UGO is equivalent.
Check Constraint
If you select Do not add the check constraint, the storage of characters converted by DRS and UGO is equivalent.

SMALLINT

SMALLINT

SMALLINT

UNSIGNED INTEGER

If you select The type remains unchanged, the storage of characters converted by DRS and UGO is equivalent.
Check Constraint
If you select Do not add the check constraint, the storage of characters converted by DRS and UGO is equivalent.

MEDIUMINT

INTEGER

MEDIUMINT

SIGNED INTEGER

If you select The type remains unchanged, the storage of characters converted by DRS and UGO is equivalent.

UNSIGNED INTEGER

If you select The type remains unchanged, the storage of characters converted by DRS and UGO is equivalent.
Check Constraint
If you select Do not add the check constraint, the storage of characters converted by DRS and UGO is equivalent.

INT

INT

INT

-

BIGINT

BIGINT

BIGINT

-

FLOAT

FLOAT4

FLOAT

FLOAT

If you select Convert type to DOUBLE PRECISION, comment out precision and scale, comment out sign and padding keywords (UNSIGNED, SIGNED, ZEROFILL), the storage of characters converted by DRS and UGO is equivalent.
Check Constraint
If you select Do not add the check constraint, the storage of characters converted by DRS and UGO is equivalent.

DOUBLE

DOUBLE PRECISION

DOUBLE

DOUBLE

If you select Convert type to DOUBLE PRECISION, comment out precision and scale, comment out sign and padding keywords (UNSIGNED, SIGNED, ZEROFILL), the storage of characters converted by DRS and UGO is equivalent.

Check Constraint

If you select Do not add the check constraint, the storage of characters converted by DRS and UGO is equivalent.

DATE

DATE

DATE

-

DATETIME

TIMESTAMP

DATETIME

-

TIMESTAMP

TIMESTAMP WITH TIME ZONE

TIMESTAMP

-

TIME

TIME

TIME

-

BIT

BIT

BIT

-

JSON

JSONB

JSONB

JSON data type conversion

If you select No conversion. Retain the JSON data type., the storage of characters converted by DRS and UGO is equivalent.

YEAR

SMALLINT

SMALLINT

Check Constraint

If you select Do not add the check constraint, the storage of characters converted by DRS and UGO is equivalent.

DECIMAL

DECIMAL

DECIMAL

-

NUMERIC

NUMERIC

NUMERIC

-