GaussDB->GaussDB(DWS)
Data Type (GaussDB) |
Data Type (GaussDB(DWS)) |
Whether to Support Mapping |
---|---|---|
TINYINT |
TINYINT |
Yes |
SMALLINT |
SMALLINT |
Yes |
INT |
INT |
Yes |
BIGINT |
BIGINT |
Yes |
NUMERIC |
NUMERIC |
Yes |
NUMERIC(P,S) |
NUMERIC(P,S) |
Yes |
REAL |
REAL |
Yes |
DOUBLE PRECISION |
DOUBLE PRECISION |
Yes |
CHAR(N) |
CHAR(N) |
Yes |
VARCHAR(N) |
VARCHAR(N) |
Yes |
NVARCHAR2 |
NVARCHAR2 |
Yes |
TEXT |
TEXT |
Yes |
BOOLEAN |
BOOLEAN |
Yes |
TIMESTAMP WITHOUT TIME ZONE |
TIMESTAMP WITHOUT TIME ZONE |
Yes |
TIMESTAMP WITH TIME ZONE |
TIMESTAMP WITH TIME ZONE |
Yes |
TIME WITHOUT TIME ZONE |
TIME WITHOUT TIME ZONE |
Yes |
TIME WITH TIME ZONE |
TIME WITH TIME ZONE |
Yes |
CHARACTER |
CHAR |
Yes |
CHARACTER VARYING |
VARCHAR2 |
Yes |
DATE |
DATE |
Yes |
BIT(N) |
BIT(N) |
Yes (only in full mode) |
BIT VARYING(N) |
BIT VARYING(N) |
Yes |
BLOB |
BLOB |
Yes |
RAW |
RAW |
Yes (only in full mode) |
BYTEA |
BYTEA |
Yes |
MONEY |
MONEY |
Yes (only in full mode) |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.