Default reverse data type mappings for Sybase data sources

The following table lists the default reverse data type mappings for Sybase data sources.

Table 1. Sybase CTLIB default reverse data type mappings
Federated Typename Federated Lower Len Federated Upper Len Federated Lower Scale Federated Upper Scale Federated Bit Data Federated Data Operators Remote Typename Remote Length Remote Scale Remote Bit Data
BIGINT - - - - - - decimal 19 0 -
BLOB - - - - - - image - - -
CHARACTER - - - - N - char - - -
CHARACTER - - - - Y - binary - - -
CLOB - - - - - - text - - -
DATE - - - - - - datetime - - -
DECIMAL - - - - - - decimal - - -
DOUBLE - - - - - - float - - -
INTEGER - - - - - - integer - - -
REAL - - - - - - real - - -
SMALLINT - - - - - - smallint - - -
TIME - - - - - - datetime - - -
TIMESTAMP - - - - - - datetime - - -
VARCHAR1 1 255 - - N - varchar - - -
VARCHAR1 256 32672 - - N - text - - -
VARCHAR 2 1 16384 - - N - varchar - - -
VARCHAR 2 16385 32672 - - N - text - - -
VARCHAR1 1 255 - - Y - varbinary - - -
VARCHAR1 256 32672 - - Y - image - - -
VARCHAR 2 1 16384 - - Y - varbinary - - -
VARCHAR 2 16385 32672 - - Y - image - - -
Note:
  1. This type mapping is valid only for CTLIB with Sybase server version 12.0 (or earlier).
  2. This type mapping is valid only for CTLIB with Sybase server version 12.5 (or later).