From Microsoft SQL Server to GaussDB
Source Data Type |
Converted Data Type |
Conversion Configuration |
---|---|---|
TINYINT |
TINYINT |
- |
SMALLINT |
SMALLINT |
- |
INT |
INT |
- |
BIGINT |
BIGINT |
- |
DECIMAL |
DECIMAL |
- |
NUMERIC |
NUMERIC |
- |
FLOAT |
FLOAT |
- |
REAL |
REAL |
- |
SMALLMONEY |
numeric(10, 4) |
- |
MONEY |
numeric(19, 4) |
- |
BIT |
BOOLEAN |
Bit datatype If you select Convert the bit type to boolean data type, the storage of characters converted by DRS and UGO is equivalent. |
DATE |
DATE |
- |
SMALLDATETIME |
SMALLDATETIME |
- |
DATETIME |
TIMESTAMP(3) |
- |
DATETIME2(n) |
TIMESTAMP(n) |
- |
DATETIMEOFFSET(n) |
TIMESTAMPTZ(n) |
datetimeoffset datatype If you select Convert the datetimeoffset type to timestamptz, the storage of characters converted by DRS and UGO is equivalent. |
TIME(p) |
TIME(p) |
- |
TIMESTAMP |
BYTEA |
- |
XML |
XML |
XML datatype If you select Convert XML data type to TEXT data type, the storage of characters converted by DRS and UGO is equivalent. |
CHAR(n) |
CHAR(n) |
Mismatch character set If you select This config will adjust the size of CHAR(n), VARCHAR(n), and NCHAR(n) such that there will not be overflow, the storage of characters converted by DRS and UGO is equivalent. |
VARCHAR(n) |
VARCHAR(n) |
Mismatch character set If you select This config will adjust the size of CHAR(n), VARCHAR(n), and NCHAR(n) such that there will not be overflow, the storage of characters converted by DRS and UGO is equivalent. |
varchar(max) |
TEXT |
VARCHAR(MAX) datatype If you select Convert VARCHAR(MAX) data type to TEXT data type, the storage of characters converted by DRS and UGO is equivalent. |
NCHAR(n) |
NCHAR(n) |
Mismatch character set If you select This config will adjust the size of CHAR(n), VARCHAR(n), and NCHAR(n) such that there will not be overflow, the storage of characters converted by DRS and UGO is equivalent. |
NVARCHAR(n) |
NVARCHAR2(n) |
- |
NVARCHAR(max) |
TEXT |
NVARCHAR(MAX) datatype If you select Convert NVARCHAR(MAX) data type to TEXT data type, the storage of characters converted by DRS and UGO is equivalent. |
BINARY(n) |
BYTEA |
- |
VARBINARY(n) |
BYTEA |
- |
VARBINARY(MAX) |
BYTEA |
VARBINARY(MAX) datatype If you select Convert VARBINARY(MAX) data type to BYTEA data type, the storage of characters converted by DRS and UGO is equivalent. |
IMAGE |
BYTEA |
IMAGE datatype If you select Convert IMAGE data type to BYTEA data type, the storage of characters converted by DRS and UGO is equivalent. |
HIERARCHYID |
BYTEA |
HIERARCHYID datatype If you select Convert HIERARCHYID data type to BYTEA data type, the storage of characters converted by DRS and UGO is equivalent. |
NTEXT |
TEXT |
NTEXT datatype If you select Convert NTEXT data type to TEXT data type, the storage of characters converted by DRS and UGO is equivalent. |
TEXT |
TEXT |
TEXT datatype If you select Convert TEXT data type to TEXT data type, the storage of characters converted by DRS and UGO is equivalent. |
UNIQUEIDENTIFIER |
UUID |
- |
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