Updated on 2023-07-03 GMT+08:00
GaussDB->MySQL
|
Data Type (GaussDB) |
Data Type (MySQL) |
Whether to Support Mapping |
|---|---|---|
|
CHARACTER |
CHAR |
Yes |
|
CHARACTER VARYING |
VARCHAR |
Yes |
|
BYTEA/BLOB/RAW |
BINARY/VARBINARY/TINYBLOB /BLOB/MEDIUMBLOB/LONGBLOB |
Yes |
|
TEXT/CLOB |
TINYTEXT/MEDIUMTEXT /LONGTEXT/ TEXT |
Yes |
|
TINYINT |
SMALLINT |
Yes |
|
SMALLINT |
SMALLINT |
Yes |
|
INTEGER |
INT |
Yes |
|
BIGINT |
BIGINT |
Yes |
|
FLOAT4 |
FLOAT |
Yes |
|
FLOAT8/DOUBLE PRECISION |
DOUBLE |
Yes |
|
DATE |
DATE |
Yes |
|
TIMESTAMP WITHOUT TIME ZONE |
DATETIME |
Yes |
|
SMALLDATETIME |
DATETIME |
Yes |
|
TIMESTAMP WITH TIME ZONE |
TIMESTAMP |
Yes |
|
TIME WITH TIME ZONE |
TIME |
Yes |
|
TIME WITHOUT TIME ZONE |
TIME |
Yes |
|
BIT |
BIT |
Yes |
|
MONEY |
VARCHAR |
Yes |
|
BOOLEAN |
BOOLEAN |
Yes |
|
NUMBER |
DECIMAL |
Yes |
|
NUMBERIC |
DECIMAL |
Yes |
|
DECIMAL |
DECIMAL |
Yes |
Parent topic: Mapping Data Types
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
