Supported data types
Each CDC Replication replication engine supports a variety of data types. When you map source and target columns for replication in Management Console, you should know which data types are compatible.
For a list of column mappings that are supported by the different engines, see Supported column mappings.
CDC Replication Engine for BigQuery
The following data types are supported:
BOOLEAN
STRING DATE |
FLOAT64 INT64 NUMERIC | NUMERIC(p,s) NUMERIC(p) BIGNUMERIC | BIGNUMERIC(p,s) BIGNUMERIC(p) TIME | TIMESTAMP DATETIME |
CDC Replication Engine for Db2 Database
The following data types are supported:
BIGINT
BINARY BLOB BOOLEAN CHAR CHARACTER FOR BIT DATA |
CLOB
DATE DBCLOB DECFLOAT DECIMAL DOUBLE |
FLOAT
GRAPHIC INTEGER LOB LONG VARCHAR LONG VARCHAR FOR BIT DATA |
LONG VARGRAPHIC
NUMERIC REAL SMALLINT TIME TIMESTAMP |
VARBINARY
VARCHAR VARCHAR FOR BIT DATA VARGRAPHIC XML |
CDC Replication Engine for Db2 for i
The following data types are supported:
BIGINT
BLOB CHAR CLOB DATE DMY DATE EUR DATE ISO |
DATE JUL
DATE MDY DATE USA DATE YMD DBCLOB DBCS EITHR DBCS GRAPHIC |
DBCS ONLY
DBCS OPEN DECIMAL DOUBLE FLOAT GRAPHIC HEX (fixed length only) |
INTEGER
REAL SMALLINT TIME EUR TIME HMS TIME ISO TIME JIS |
TIME USA
TIMESTAMP VARCHAR VARGRAPHIC ZONED NUMERIC |
CDC Replication Engine for Db2 for z/OS
The following data types are supported:
BIGINT
BINARY BLOB CHAR CHARACTER CHARACTER FOR BIT DATA |
CLOB
DATE DBCLOB DECFLOAT DECIMAL DOUBLE |
FLOAT
GRAPHIC INTEGER LOB REAL ROWID |
SMALLINT
TIME TIMESTAMP TIMESTAMP WITH TIME ZONE VARBINARY VARCHAR |
VARCHAR FOR BIT DATA
VARGRAPHIC XML |
CDC Replication Engine for Db2 for z/OS Remote Source
The following data types are supported:
BIGINT
BINARY BLOB CHAR CHARACTER CHARACTER FOR BIT DATA |
CLOB
DATE DBCLOB DECFLOAT DECIMAL DOUBLE |
FLOAT
GRAPHIC INTEGER LOB REAL ROWID |
SMALLINT
TIME TIMESTAMP TIMESTAMP WITH TIME ZONE VARBINARY VARCHAR |
VARCHAR FOR BIT DATA
VARGRAPHIC XML |
CDC Replication Engine for FlexRep
The CDC Replication Engine for FlexRep applies data to the target using the functionality and data types available with the JDBC4 specification. The CDC Replication Engine for FlexRep does not support all the data types supported by each driver. If you have a question about a data type not on this list, please contact IBM®.
BIGINT
BINARY BIT BLOB BOOLEAN CHAR |
CLOB
DATE DECIMAL DOUBLE FLOAT GRAPHIC |
HEX (fixed length only)
INTEGER LONG NVARCHAR LONG VARBINARY LONG VARCHAR NCHAR |
NCLOB
NUMERIC NVARCHAR REAL SMALLINT SQLXML |
TIME
TIMESTAMP TINYINT VARBINARY VARCHAR |
CDC Replication Engine for Informix
The following data types are supported:
BIGINT
BIGSERIAL BLOB BOOLEAN BYTE CHAR |
CHARACTER
CHARACTER VARYING CLOB DATE DATETIME DATETIME HOUR TO SECOND |
DATETIME YEAR TO FRACTION(5)
DECIMAL1 FLOAT INT8 INTEGER LVARCHAR |
MONEY
NCHAR NUMERIC NVARCHAR REAL SERIAL |
SERIAL8
SMALLFLOAT SMALLINT TEXT VARCHAR |
- Only fixed-point decimal is supported.
CDC Replication Engine for Kafka
The following data types are supported:
BYTES
DATA |
DECIMAL
DOUBLE |
DURATION
INT |
LONG
STRING |
TIMESTAMP-MICROS
TIME-MILLIS |
CDC Replication Engine for MariaDB Source
The following data types are supported:
TINYINT
SMALLINT INTEGER BIGINT DECIMAL |
FLOAT
DOUBLE CHAR VARCHAR BOOLEAN |
TINYTEXT
TEXT MEDIUMTEXT LONGTEXT DATE |
TIME
DATETIME TIMESTAMP BINARY VARBINARY |
TINYBLOB
BLOB MEDIUMBLOB LONGBLOB JSON |
CDC Replication Engine for Microsoft SQL Server
The following data types are supported:
BIGINT
BINARY BIT CHAR DATE DATETIME |
DATETIME2
DATETIMEOFFSET DECIMAL FLOAT GEOGRAPHY GEOMETRY |
IMAGE
INTEGER MONEY NCHAR NTEXT NUMERIC |
NVARCHAR
REAL ROWVERSION SMALLDATETIME SMALLMONEY SQL_VARIANT |
TIME
TINYINT UNIQUEIDENTIFIER VARBINARY VARBINARY(MAX) |
CDC Replication Engine for MySQL Source
The following data types are supported:
TINYINT
SMALLINT INTEGER BIGINT DECIMAL |
FLOAT
DOUBLE CHAR VARCHAR BOOLEAN |
TINYTEXT
TEXT MEDIUMTEXT LONGTEXT DATE |
TIME
DATETIME TIMESTAMP BINARY VARBINARY |
TINYBLOB
BLOB MEDIUMBLOB LONGBLOB JSON |
CDC Replication Engine for Netezza Technology
The following data types are supported:
BIGINT
BOOLEAN BOOL BYTEINT CHAR |
CHARACTER
CHARACTER VARYING DATE DECIMAL DOUBLE PRECISION |
FLOAT
FLOAT(p) INTEGER NCHAR NUMERIC |
NUMERIC(p,s)
NUMERIC(p) NVARCHAR REAL SMALLINT |
TIME
TIMESTAMP VARBINARY VARCHAR |
CDC Replication Engine for Oracle databases
The following data types are supported:
BIGINT
BINARY_DOUBLE BINARY_FLOAT BLOB CHAR CLOB |
DATE
FLOAT INTEGER INTERVAL DAY TO SECOND INTERVAL DAY TO MONTH LOB |
LONG RAW
LONG VARCHAR NCHAR NCLOB NUMERIC NVARCHAR2 |
RAW
REAL ROWID TIMESTAMP TIMESTAMP WITH TIME ZONE TIMEZONE |
VARCHAR2
XML XMLTYPE |
CDC Replication Engine for Oracle (Trigger edition)
The following data types are supported:
BIGINT
BINARY_DOUBLE BINARY_FLOAT BLOB CHAR CLOB |
DATE
FLOAT INTEGER INTERVAL DAY TO SECOND INTERVAL DAY TO MONTH LOB |
LONG RAW
LONG VARCHAR NCHAR NCLOB NUMERIC NVARCHAR2 |
RAW
REAL ROWID TIMESTAMP TIMESTAMP WITH TIME ZONE TIMEZONE |
VARCHAR2
XML XMLTYPE |
CDC Replication Engine for Oracle XStream
The following data types are supported:
BIGINT
BINARY_DOUBLE BINARY_FLOAT BLOB CHAR |
CLOB
DATE FLOAT INTEGER INTERVAL DAY TO SECOND |
INTERVAL DAY TO MONTH
LOB LONG RAW LONG VARCHAR NCHAR |
NCLOB
NUMERIC NVARCHAR2 RAW REAL |
TIMESTAMP
TIMESTAMP WITH TIME ZONE VARCHAR2 XMLTYPE |
CDC Replication Engine for PostgreSQL
The following data types are supported:
BIGINT
BINARY BOOLEAN BIT BIT VARYING BYTEA |
CHARACTER
CHARACTER VARYING DATE DECIMAL DOUBLE FLOAT |
INTEGER
JSON JSONB MONEY NUMERIC REAL |
SMALLINT
TEXT TIME TIMESTAMP TIMESTAMP WITH TIME ZONE |
UUID
XML |
CDC Replication Engine for Sybase
The following data types are supported:
BIGDATETIME
BIGINT BIGTIME BINARY BIT CHAR DATE |
DATETIME
DECIMAL FLOAT IMAGE INTEGER MONEY NCHAR |
NTEXT
NUMERIC NVARCHAR REAL SMALLDATETIME SMALLINT SMALLMONEY |
TEXT
TIME TIMESTAMP TINYINT UNICHAR UNITEXT UNIVARCHAR |
VARBINARY
VARCHAR |
CDC Replication Engine for Teradata
The following data types are supported:
BYTE
BYTEINT CHAR DATE DECIMAL |
DOUBLE
FLOAT GRAPHIC IMAGE |
INTEGER
LONG VARCHAR NUMBER NUMERIC |
REAL
SMALLINT TIME TIMESTAMP |
TIMESTAMP WITH TIME ZONE
VARBYTE VARCHAR VARGRAPHIC |