When you execute a CREATE TABLE statement, SAP Sybase IQ 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 |
| VARBIT(n) | Binary(n) |
| LONG VARBIT | Binary(2G) |
| TINYINT | Integer |
| SMALLINT | Integer |
| INTEGER | Integer |
| BIGINT | Numeric(32) |
| UNSIGNED TINYINT | Numeric(11) |
| UNSIGNED SMALLINT | Numeric(11) |
| UNSIGNED INTEGER | Numeric(11) |
| UNSIGNED BIGINT | Numeric(32) |
| CHAR(n) | Character(n) |
| VARCHAR(n) | VarChar(n) |
| LONG VARCHAR | VarChar(65000) |
| NCHAR(n) | NChar(n) |
| NVARCHAR(n) | NVarChar(n) |
| LONG NVARCHAR | NVarChar(32500) |
| BINARY(n) | Binary(n) |
| VARBINARY(n) | Binary(n) |
| LONG BINARY | Binary(2G) |
| DECIMAL(precision, scale) | Numeric(precision+3) |
| NUMERIC(precision, scale) | Numeric(precision+3) |
| SMALLMONEY | Money |
| MONEY | Money |
| REAL | Double |
| DOUBLE | Double |
| FLOAT(n) | Double |
| DATE | Date |
| TIME | Time |
| TIMESTAMP | TimeStamp |
| TIMESTAMP WITH TIMEZONE | Char(254) |
| BIGDATE | datetime |
| BIGDATETIME | datetime |
| XML | Binary(2G) |
| ST_GEOMETRY | Binary(2G) |
| UNIQUEIDENTIFIER | Binary(2G) |