When you use a CREATE TABLE statement to create a remote table on an Oracle server, Sybase IQ converts the IQ data types to corresponding Oracle data types:
Sybase IQ data type |
Oracle data type |
---|---|
BIGINT |
NUMBER(20,0) |
BINARY(n) |
if (n > 255) LONG RAW else RAW(n) |
BIT |
NUMBER(1,0) |
CHAR(n) |
If (n > 255) LONG else VARCHAR(n) |
CHARACTER VARYING(n) |
VARCHAR2(n) |
CHARACTER(n) |
VARCHAR2(n) |
DATE |
DATE |
DATETIME |
DATE |
DECIMAL(prec, scale) |
NUMBER(prec, scale) |
DOUBLE |
FLOAT |
FLOAT |
FLOAT |
INT |
NUMBER(11,0) |
LONG BINARY |
LONG RAW |
LONG VARCHAR |
LONG or CLOB |
MONEY |
NUMBER(19,4) |
NUMERIC(prec, scale) |
NUMBER(prec, scale) |
REAL |
FLOAT |
SMALLDATETIME |
DATE |
SMALLINT |
NUMBER(5,0) |
SMALLMONEY |
NUMBER(10,4) |
TIME |
DATE |
TIMESTAMP |
DATE |
TINYINT |
NUMBER(3,0) |
UNIQUEIDENTIFIERSTR |
CHAR(36) |
UNSIGNED BIGINT |
NUMBER(20,0) |
UNSIGNED INT |
NUMBER(11,0) |
UNSIGNED INTEGER |
NUMBER(11,0) |
VARBINARY(n) |
if (n > 255) LONG RAW else RAW(n) |
VARCHAR(n) |
VARCHAR2(n) |