Connect CDC supports several data types. In the tables of supported datatypes in the following pages, the Numeric Length column shows the maximum supported number of numeric digits, while Display Length is the maximum number of characters, or the numeric length plus an included sign, if any.
An asterisk (*) means the length is taken from the column definition in the DBMS catalog. For decimal numeric types, the length is the number of positions to the left of the decimal point. For example, a NUMERIC(10,2) column has a length of 8.
Related Topics:
|
Datatype |
Category |
NumericLength |
Display Length |
|---|---|---|---|
|
BIGINT |
Integral Numeric |
19 |
20 |
|
BYTEINT |
Integral Numeric |
3 |
4 |
|
CHAR |
Character |
|
Max length=64K |
|
DATE |
Date |
|
10 |
|
DECIMAL a |
Decimal Numeric |
|
|
|
DOUBLE PRECISION b |
ApproximateNumeric |
|
|
|
INTEGER |
Integral Numeric |
10 |
11 |
|
LONG VARCHAR |
Character |
|
Max Length=64K |
|
SMALLINT |
Integral Numeric |
|
6 |
|
TIME(P) c |
Time |
|
8 |
|
TIMESTAMP(P) d |
Date/Interval |
|
26 |
|
VARCHAR |
Character |
|
Max Length=64K |
| aIncludes NUMERIC bIncludes FLOAT and REAL cTIME WITH TIME ZONE is not supported dTIMESTAMP with Time Zone is not supported |