Supported datatypes per DBMS - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

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