The DBMS-specific sections on the following pages describe the Connect CDC datatype support for the following DBMSs:
For each DBMS, the Connect CDC-supported datatypes are displayed in tables. Unless otherwise specified, support is for both sending and receiving columns, Replication and Copy, and all supported DBMSs.
The table below specifies the datatypes that Connect CDC supports. To determine the extent of the support for each datatype and the datatypes with which each can be mapped, see Datatype conversion rules and the category-specific sections that begin on Character and long character categories.
|
DB2 |
Informix |
MSS / AZ |
MySQL |
Oracle |
PostgreSQL |
Snowflake |
Sybase |
Teradata |
|
|---|---|---|---|---|---|---|---|---|---|
|
IBM i |
UDB |
||||||||
|
Bigint |
Bigint |
|
Bigint |
Bigint |
|
Bigint |
Bigint |
|
Bigint |
|
|
|
|
Binary |
Binary |
|
|
Binary |
Binary |
|
|
|
|
|
Bit |
Bit |
|
|
|
Bit |
|
|
Blob |
|
|
|
Blob |
Blob |
|
|
|
|
|
|
|
|
|
|
|
Boolean |
Boolean |
|
|
|
|
|
|
|
|
|
Bytea |
|
|
|
|
|
|
|
|
|
|
|
|
|
Byteint |
|
Char |
Char |
Char |
Char |
Char |
Char |
Char |
Char / Character |
Char |
Char |
|
Char ForBit |
Char ForBit |
|
|
|
|
|
|
|
|
|
Clob |
|
|
|
|
Clob |
|
|
|
|
|
Date |
Date |
Date |
Date |
Date |
Date |
Date |
Date |
|
Date |
|
|
|
Datetime |
Datetime |
Datetime |
|
|
Datetime |
Datetime |
|
|
|
|
|
Datetime2(p) |
|
|
|
|
|
|
|
|
|
|
Datetimeoffset(p) |
|
|
|
|
|
|
|
Dbclob |
|
|
|
|
|
|
|
|
|
|
Decimal |
Decimal |
Decimal |
Decimal |
Decimal |
Decimal |
Decimal |
Decimal |
Decimal |
Decimal |
|
Double |
Double |
DoublePrecision |
Double Precision |
Double |
DoublePrecision |
DoublePrecision |
Double / Double Precision |
DoublePrecision |
DoublePrecision |
|
Float |
Float |
Float |
Float |
Float |
Float |
|
Float |
Float |
Float |
|
|
|
|
|
|
|
|
Float4 |
|
|
|
|
|
|
|
|
|
|
Float8 |
|
|
|
|
|
|
GEOGRAPHY |
|
|
|
|
|
|
|
|
|
|
GEOMETRY |
|
|
|
|
|
|
|
Graphic |
Graphic |
|
|
|
|
|
|
|
|
|
|
|
|
Image |
|
|
|
|
Image |
|
|
Integer |
Integer |
Integer |
Integer |
|
Integer |
Integer |
Integer |
Integer |
Integer |
|
|
|
Interval |
|
|
|
|
|
|
|
|
|
|
|
|
Int |
|
|
Int |
|
|
|
|
|
|
|
|
Long |
|
|
|
|
|
|
|
|
|
Longblob |
|
|
|
|
|
|
|
|
|
|
|
Longraw |
|
|
|
|
|
|
|
|
|
Longtext |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Long Varchar |
|
|
|
|
|
Mediumblob |
|
|
|
|
|
|
|
|
|
|
Mediumint |
|
|
|
|
|
|
|
|
|
|
Mediumtext |
|
|
|
|
|
|
|
|
Money |
Money |
|
|
Money |
|
Money |
|
|
|
|
Nchar |
Nchar |
Nchar |
Nchar |
|
|
|
|
|
|
|
|
|
|
Nclob |
|
|
|
|
|
|
|
|
Ntext |
|
|
|
|
|
|
|
|
|
|
|
|
Number |
|
Number |
|
Number |
|
Numeric |
Numeric |
Numeric |
Numeric |
Numeric |
Numeric |
Numeric |
Numeric |
Numeric |
Numeric |
|
|
|
Nvarchar |
Nvarchar |
Nvarchar |
|
|
|
|
|
|
|
|
|
|
|
Nvarchar2 |
|
|
|
|
|
|
|
|
Nvarchar(max) |
|
|
|
|
|
|
|
|
|
|
|
|
Raw |
|
|
|
|
|
Real |
Real |
Real |
Real |
Real |
Real |
Real |
Real |
Real |
Real |
|
|
|
|
|
|
SDO_GEOMETRY |
|
|
|
|
|
|
|
|
|
|
ST_GEOMETRY |
|
|
|
|
|
|
|
Serial |
|
Serial |
|
|
|
|
|
|
|
|
|
Smalldatetime |
|
|
|
|
Smalldatetime |
|
|
|
|
Smallfloat |
|
|
|
|
|
|
|
|
Smallint |
Smallint |
Smallint |
Smallint |
Smallint |
Smallint |
Smallint |
Smallint |
Smallint |
Smallint |
|
|
|
|
Smallmoney |
|
|
|
|
Smallmoney |
|
|
|
|
|
|
|
|
|
String |
|
|
|
|
|
|
Text |
Text |
|
Text |
Text |
Text |
|
|
Time |
Time |
|
Time |
Time |
|
Time |
Time |
|
Time |
|
|
|
|
Time(p) |
|
|
|
|
|
Time(p) |
|
Timestamp |
Timestamp |
|
|
|
Timestamp |
Timestamp |
Timestamp |
|
Timestamp |
|
|
|
|
|
Timestamp(p) |
Timestamp(p) |
|
|
|
Timestamp(p) |
|
|
|
|
|
|
|
|
Timestamp_LTZ |
|
|
|
|
|
|
|
|
|
|
Timestamp_NTZ |
|
|
|
|
|
|
|
Tinyblob |
|
|
|
|
|
|
|
|
|
Tinyint |
Tinyint |
|
|
|
Tinyint |
|
|
|
|
|
|
Tinytext |
|
|
|
|
|
|
|
|
|
UniqueIdentifier |
|
|
|
|
|
|
|
|
|
|
Varbinary |
|
|
|
Varbinary |
Varbinary |
|
|
|
|
|
Varbinary(max) |
Varbinary(max) |
|
|
|
Varbinary(max) |
|
|
Varchar |
Varchar |
Varchar |
Varchar |
Varchar |
Varchar |
Varchar |
Varchar |
Varchar |
Varchar |
|
Varchar For Bit |
Varchar For Bit |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Varchar2 |
|
|
|
|
|
|
|
|
Varchar(max) |
|
|
|
|
|
|
|
Vargraphic |
Vargraphic |
|
|
|
|
|
|
|
|
|
|
|
|
XML |
|
|
|
|
|
|
|
|
|
|
|
|
XMLTYPE |
|
|
|
|
|
|
|
|
|
Year |
|
|
|
|
|