Sybase - 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

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.