Data Type (GaussDB(for openGauss)) |
Data Type (MySQL) |
Whether to Support Mapping |
|---|---|---|
CHARACTER |
CHAR |
Yes |
CHARACTER VARYING |
VARCHAR |
Yes |
BYTEA/BLOB/RAW |
BINARY/VARBINARY/TINYBLOB /BLOB/MEDIUMBLOB/LONGBLOB |
Yes |
JSON |
JSON |
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 |