When you issue a CREATE TABLE statement, Sybase IQ automatically converts the data types to the corresponding Adaptive Server Enterprise data types. The following table describes the Sybase IQ to Adaptive Server Enterprise data type conversions.
Sybase IQ data type |
ASE default data type |
|---|---|
bit |
bit |
tinyint |
tinyint |
smallint |
smallint |
int |
int |
integer |
integer |
decimal [defaults precision=30, scale=6] |
numeric(30,6) |
decimal(128,128) |
not supported |
numeric [defaults precision=30, scale=6] |
numeric(30,6) |
numeric(128,128) |
not supported |
float |
real |
real |
real |
double |
float |
smallmoney |
numeric(10,4) |
money |
numeric(19,4) |
date |
datetime |
time |
datetime |
timestamp |
datetime |
datetime |
datetime |
char(n) |
char(n) |
character(n) |
char(n) |
varchar(n) |
varchar(n) |
character varying(n) |
varchar(n) |
binary(n) |
binary(n) |
varbinary(n) |
varbinary(n) |
text |
text |
bigint |
numeric(20,0) |
