When you issue a CREATE TABLE statement, Sybase IQ automatically converts the data types to the corresponding Oracle data types. The following table describes the Sybase IQ to Oracle data type conversions.
Sybase IQ data type |
Oracle data type |
|---|---|
bit |
number(1,0) |
tinyint |
number(3,0) |
smallint |
number(5,0) |
int, integer |
number(11,0) |
bigint |
number(20,0) |
decimal (precision, scale) |
number(prec, scale) |
numeric (precision, scale) |
number(prec, scale) |
float |
float |
real |
real |
smallmoney |
numeric(13,4) |
money |
number(19,4) |
date |
date |
time |
date |
smalldatetime |
date |
timestamp |
date |
datetime |
date |
char(n) |
if (n>255) long else varchar(n) |
varchar(n) |
if (n>2000) long else varchar(n) |
binary(n) |
if (n>255) long raw else raw(n) |
varbinary(n) |
if (n>255) long raw else raw(n) |
long binary |
long raw |
