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 |
- |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot