As shown below, Connect CDC supports distribution of most Sybase SQL datatypes. 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 |
Numeric Length |
Display Length |
|---|---|---|---|
|
BIT |
Integral Numeric |
1 |
1 |
|
CHARACTER, CHAR |
Character |
|
<=255 |
|
DATETIME a |
Date/Interval |
|
20 |
|
DECIMAL, DEC |
Decimal Numeric |
* |
|
|
DOUBLE PRECISION |
Approximate Numeric |
|
|
|
FLOAT |
Approximate Numeric |
|
|
|
IMAGE bc |
Long Binary |
|
|
|
INTEGER, INT |
Integral Numeric |
10 |
11 |
|
MONEY |
Decimal Numeric d |
|
|
|
NUMERIC |
Decimal Numeric |
* |
|
|
REAL |
Approximate Numeric |
|
|
|
SMALLDATETIME a |
Date |
|
20 |
|
SMALLINT |
Integral Numeric |
5 |
6 |
|
SMALLMONEY |
Decimal Numeric e |
|
|
|
TEXT bc |
Long Character |
|
|
|
TINYINT |
Integral Numeric |
3 |
3 |
|
VARCHAR, CHARACTER VARYING |
Character |
|
* |
|
a See the tablefor the supported range of dates. b Copy only, Sybase targets only (see Copying Long Character or Long Binary data). c Binary type or long type columns cannot be used in data enhancement, expressions or gate conditions. d These values have a DBMS-defined implicit precision of 19 and scale of 4. e These values have a DBMS-defined implicit precision of 10 and scale of 4. |