Table 218 lists the data type mapping that is performed when the
source data type is a Cloudscape data type.
Table 218. Data type mapping from Cloudscape source data types
| Cloudscape source data type | DB2 mirror data type | DB2 Everyplace device data type | Cloudscape device data type |
|---|---|---|---|
| BIGINT | BIGINT | VARCHAR, | BIGINT |
| BIT | unsupported | unsupported | unsupported |
| BIT VARYING | LONG VARCHAR FOR BIT DATA | BLOB | BIT VARYING |
| BOOLEAN | BOOLEAN | SMALLINT | SMALLINT |
| CHAR | CHAR | CHAR | CHAR |
| DATE | DATE | DATE | DATE |
| DECIMAL | DECIMAL | DECIMAL | DECIMAL |
| DOUBLE PRECISION | FLOAT | VARCHAR, | DOUBLE PRECISION |
| FLOAT | FLOAT | VARCHAR, | FLOAT |
| INT | INT | INT | INT |
| LONG NVARCHAR | LONG VARCHAR | VARCHAR | LONG VARCHAR |
| LONG BIT VARYING | LONG BIT VARYING | BLOB | LONG BIT VARYING |
| NATIONAL CHAR | unsupported | unsupported | unsupported |
| NATIONAL CHAR VARYING | unsupported | unsupported | unsupported |
| NUMERIC | NUMERIC | DECIMAL | NUMERIC |
| REAL | REAL | VARCHAR | REAL |
| SMALLINT | SMALLINT | SMALLINT | SMALLINT |
| TIME | TIME | TIME | TIME |
| TIMESTAMP | TIMESTAMP | TIMESTAMP | TIMESTAMP |
| TINYINT | SMALLINT | SMALLINT | SMALLINT |
| VARCHAR | VARCHAR | VARCHAR | VARCHAR |
Related reference