Help Center/ Data Replication Service/ FAQs/ Data-Level Comparison/ Which of the Following Data Types Are Not Supported By Value Comparison?
Updated on 2025-07-24 GMT+08:00

Which of the Following Data Types Are Not Supported By Value Comparison?

DRS's data comparison allows you to check whether the data in the source database is the same as that in the destination database.

DRS does not support value comparison for the data types shown here. During value comparison, these data types are automatically ignored.

Table 1 Data types that do not support value comparison

Source DB Type

Data Type

Oracle

BLOB, NCLOB, CLOB, LONG RAW, LONG, INTERVAL DAY TO SECOND, INTERVAL YEAR TO MONTH, UROWID, BFILE, XMLTYPE, SDO_GEOMETRY

MongoDB

_id is of the BINDATA type.

Microsoft SQL Server

TEXT, NTEXT, IMAGE, BINARY, VARBINARY, HIERARCHYID, XML, TIMESTAMP

DRS does not support value comparison for the following primary key types. During value comparison, the following primary key types are grouped into a specified table that does not support comparison.

Table 2 Primary key type that does not support value comparison.

Source DB Type

Data Type

MySQL

TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB, TINYTEXT, TEXT, MEDIUMTEXT, LONGTEXT, FLOAT, FLOAT UNSIGNED, DOUBLE, DOUBLE UNSIGNED, TIMESTAMP, DATE, DATETIME, TIME, BINARY, VARBINARY, GEOMETRY, JSON

GaussDB

TEXT, CLOB, BLOB, BYTEA, INTERVAL DAY TO SECOND, INTERVAL, REAL, DOUBLE PRECISION, BOOL, TIME, TIMETZ, TIMESTAMP, TIMESTAMPTZ, DATE

Note: During data comparison from GaussDB Distributed to GaussDB Distributed, if a primary key type that does not support value comparison is used as a composite primary key and the composite primary key contains the primary key type that supports value comparison, value comparison can be performed.

Oracle

BLOB, NCLOB, CLOB, LONG RAW, LONG, INTERVAL DAY TO SECOND, INTERVAL YEAR TO MONTH, UROWID, BFILE, XMLTYPE, SDO_GEOMETRY, BINARY_FLOAT, BINARY_DOUBLE, FLOAT, RAW, TIMESTAMP, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH LOCAL TIME ZONE, DATE

PostgreSQL

REAL, DOUBLE PRECISION, MONEY, TEXT, BYTEA, TIMESTAMP WITHOUT TIME ZONE, TIMESTAMP WITH TIME ZONE, DATE, TIME WITHOUT TIME ZONE, TIME WITH TIME ZONE, INTERVAL, BOOLEAN, ENUMERATED TYPES, POINT, LINE, LSEG, BOX, PATH, POLYGON, CIRCLE, CIDR, INET, MACADDR, MACADDR8, BIT, BIT VARYING, TSVECTOR, TSQUERY, XML, JSON, ARRAY, COMPOSITE TYPES, INT4RANGE, INT8RANGE, NUMRANGE, TSRANGE, TSTZRANGE, DATERANGE

Microsoft SQL Server

FLOAT, REAL, DATE, DATETIME, DATETIME2, DATETIMEOFFSET, TIME, TIMESTAMP, TEXT, NTEXT, IMAGE, BINARY, VARBINARY, HIERARCHYID, XML, BIT