When you issue a CREATE TABLE statement, the database server automatically converts the data types to the corresponding Advantage Database Server data types using the following data type conversions.
| SAP Sybase IQ Data Type | ADS Default Data Type |
|---|---|
| BIT | Logical |
| TINYINT, SMALLINT, INT, INTEGER | Integer |
| BIGINT | Numeric(32) |
| DECIMAL(p,s), NUMERIC(p,s) | Numeric(p+3) |
| DATE | Date |
| TIME | Time |
| DATETIME, TIMESTAMP | TimeStamp |
| MONEY, SMALLMONEY | Money |
| FLOAT, REAL | Double |
| CHAR(n), VARCHAR(n), LONG VARCHAR | Char(n) |
| BINARY(n), VARBINARY(n), LONG BINARY | Blob |