ECDA Option for Oracle constructs syntax for Oracle datatypes.
This table illustrates datatype conversion that is performed when a create table or alter table statement is processed using ECDA Option for Oracle with Adaptive Server.
Adaptive Server Datatype |
Oracle Datatype |
|---|---|
bit |
char(1) |
tinyint |
number(3,0) |
smallint |
number(4,0) |
int |
number(10,0) |
smallmoney |
number(10,4) |
money |
number(19,4) |
float |
float |
real |
float |
decimal(p,s) |
number(p,s) |
numeric(p,s) |
number(p,s) |
char(n) |
char(n) |
varchar(n) |
varchar2(n) |
unichar(n) |
nchar(n) |
univarchar(n) |
nvarchar2(n) |
binary(n) |
raw(n) |
varbinary(n) |
raw(n) |
timestamp |
raw(16) |
text |
CLOB |
image |
BLOB |
datetime |
date |
smalldatetime |
date |
date |
date |
time |
timestamp |
When a create existing table command is processed, the datatype for each column specifies the type of conversion to be performed from the Oracle columns to Adaptive Server columns during query processing. This table describes the datatypes that can be used for existing Oracle datatypes.
Adaptive Server Datatype |
Oracle Datatype |
|---|---|
int, smallint, tinyint, float, double, numeric, decimal |
number |
datetime |
date |
date |
date |
time |
timestamp |
datetime |
timestamp |
char(n) |
char(n) |
varchar(n) |
varchar2(n) up to 4000 bytes |
text |
CLOB |
binary(n) or varbinary(n) |
raw(n) up to 4000 bytes |
image |
BLOB |