Table 215 lists the data type mapping that is performed when the
source data type is a Sybase data type.
Table 215. Data type mapping from Sybase source data types
| Sybase source data type | DB2 mirror data type | DB2 Everyplace device data type | Cloudscape device data type |
|---|---|---|---|
| BINARY(n) | unsupported | unsupported | unsupported |
| BIT | SMALLINT | SMALLINT | SMALLINT |
| CHAR(n) | CHARACTER | CHARACTER | CHARACTER |
| DATETIME | TIMESTAMP | TIMESTAMP | TIMESTAMP |
| DECIMAL[(p[,s])] | DECIMAL | DECIMAL | DECIMAL |
| DOUBLE PRECISION | FLOAT | VARCHAR | DOUBLE PRECISION |
| FLOAT(p) | FLOAT | VARCHAR | DOUBLE PRECISION |
| IMAGE | LONG VARCHAR FOR BIT DATA | BLOB | LONG BIT VARYING |
| INT | INTEGER | INT | INT |
| MONEY | DECIMAL | DECIMAL | DECIMAL |
| NCHAR(n) | CHARACTER | CHARACTER | CHARACTER |
| NUMERIC(p,s) | NUMERIC | DECIMAL | NUMERIC |
| NVARCHAR(n) | VARCHAR | VARCHAR | VARCHAR |
| REAL | REAL | VARCHAR | REAL |
| SMALLDATETIME | TIMESTAMP | TIMESTAMP | TIMESTAMP |
| SMALLINT | SMALLINT | SMALLINT | SMALLINT |
| SMALLMONEY | DECIMAL | DECIMAL | DECIMAL |
| TEXT | LONG VARCHAR | VARCHAR | LONG VARCHAR |
| TINYINT | unsupported | unsupported | unsupported |
| VARBINARY(n) | VARCHAR() FOR BIT DATA | BLOB | BIT VARYING |
| VARCHAR(n) | VARCHAR | VARCHAR | VARCHAR |
Related reference