Updated on 2024-11-07 GMT+08:00

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

-