跳到主要内容
版本：3.x

数据类型支持说明

提示

本文仅列举在同步过程中不支持的字段类型，不在范围的数据源逐步补充。

Oracle 作为源​

目标不支持字段
OracleRAW，LONG_RAW，BFILE，XMLTYPE，STRUCT
MongoDBRAW，LONG_RAW，BFILE，XMLTYPE，STRUCT，INTERVAL DAY(2) TO SECOND(6),INTERVAL YEAR(4) TO MONTH
SQL ServerRAW，LONG_RAW，BFILE，XMLTYPE，STRUCT，INTERVAL DAY(2) TO SECOND(6),INTERVAL YEAR(4) TO MONTH
MySQLRAW，LONG_RAW，BFILE，XMLTYPE，STRUCT，INTERVAL DAY(2) TO SECOND(6),INTERVAL YEAR(4) TO MONTH
PostgreSQLRAW，LONG_RAW，BFILE，XMLTYPE，STRUCT，INTERVAL DAY(2) TO SECOND(6),INTERVAL YEAR(4) TO MONTH
Elastic SearchRAW，LONG_RAW，BFILE，XMLTYPE，STRUCT，INTERVAL DAY(2) TO SECOND(6),INTERVAL YEAR(4) TO MONTH
KafkaRAW，LONG_RAW，BFILE，XMLTYPE，STRUCT，INTERVAL DAY(2) TO SECOND(6),INTERVAL YEAR(4) TO MONTH
ClickHouseRAW，LONG_RAW，BFILE，XMLTYPE，STRUCT，INTERVAL DAY(2) TO SECOND(6),INTERVAL YEAR(4) TO MONTH,BLOB

MySQL 作为源​

目标不支持字段
OracleGEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION,DOUBLE UNSIGNED,DOUBLE UNSIGNED,BINARY,VARBINARY,TINYBLOB,BLOB,LONGBLOB
MongoDBGEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION,DOUBLE UNSIGNED,DOUBLE UNSIGNED,BINARY,VARBINARY,TINYBLOB,BLOB,LONGBLOB
SQL ServerGEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION,DOUBLE UNSIGNED,DOUBLE UNSIGNED,BINARY,VARBINARY,TINYBLOB,BLOB,LONGBLOB
MySQLGEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION
PostgreSQLGEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION,DOUBLE UNSIGNED,DOUBLE UNSIGNED,BINARY,VARBINARY,TINYBLOB,BLOB,LONGBLOB
Elastic SearchGEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION,DOUBLE UNSIGNED,DOUBLE UNSIGNED,BINARY,VARBINARY,TINYBLOB,BLOB,LONGBLOB
KafkaGEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION,DOUBLE UNSIGNED,DOUBLE UNSIGNED,BINARY,VARBINARY,TINYBLOB,BLOB,LONGBLOB
ClickHouseGEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION,DOUBLE UNSIGNED,BINARY,VARBINARY,TINYBLOB,BLOB,LONGBLOB

SQL Server 作为源​

提示

受 SQL Server 本身机制的影响，如果待同步的表没有主键且包含 ntext/text/image 类型时，一旦该表发生更新或者删除操作，可能会导致更新或删除多条数据（多条数据中，仅前文中字段的值不一致，其余字段值都一致的情况下）。

目标不支持字段
Oraclexml, geometry, geography
MongoDBxml, geometry, geography
MySQLxml, geometry, geography
PostgreSQLxml, geometry, geography
Elastic Searchxml, geometry, geography
Kafkaxml, geometry, geography
ClickHousexml, geometry, geography,binary,varbinary,image

PG 作为源​

目标不支持字段
Oraclepoint, line, lseg, box, path, polygon, circle, int4range, int8range, numrange, tsrange, tstzrange, daterange, macaddr8, uuid, xml
MongoDBpoint, line, lseg, box, path, polygon, circle, int4range, int8range, numrange, tsrange, tstzrange, daterange, macaddr8, uuid, xml
SQL Serverpoint, line, lseg, box, path, polygon, circle, int4range, int8range, numrange, tsrange, tstzrange, daterange, macaddr8, uuid, xml
MySQLpoint, line, lseg, box, path, polygon, circle, int4range, int8range, numrange, tsrange, tstzrange, daterange, macaddr8, uuid, xml
PostgreSQL'int4range', 'int8range', 'numrange', 'tsrange', 'tstzrange', 'daterange'
Elastic Searchpoint, line, lseg, box, path, polygon, circle, int4range, int8range, numrange, tsrange, tstzrange, daterange, macaddr8, uuid, xml
Kafkapoint, line, lseg, box, path, polygon, circle, int4range, int8range, numrange, tsrange, tstzrange, daterange, macaddr8, uuid, xml
ClickHousepoint, line, lseg, box, path, polygon, circle, int4range, int8range, numrange, tsrange, tstzrange, daterange, macaddr8, uuid, xml, bytea

MongoDB 作为源​

目标不支持字段
OracleJAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY
SQL ServerJAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY
MySQLJAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY
PostgreSQLJAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY
Elastic SearchJAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY
KafkaJAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY
ClickHouseJAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY,BINARY,NULL