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 |
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 |