ASA SQL User's Guide
Server Classes for Remote Data Access
ODBC-based server classes
Server class oraodbc
When you issue a CREATE TABLE statement, Adaptive Server Anywhere automatically converts the data types to the corresponding Oracle data types. The following table describes the Adaptive Server Anywhere to Oracle data type conversions.
Adaptive Server Anywhere data type | Oracle data type |
---|---|
bit | number(1,0) |
tinyint | number(3,0) |
smallint | number(5,0) |
int | number(11,0) |
bigint | number(20,0) |
decimal(prec, scale) | number(prec, scale) |
numeric(prec, scale) | number(prec, scale) |
float | float |
real | real |
smallmoney | numeric(13,4) |
money | number(19,4) |
date | date |
time | date |
timestamp | date |
smalldatetime | date |
datetime | date |
char(n) | if (n > 255) long else varchar(n) |
varchar(n) | if (n > 2000) long else varchar(n) |
long varchar | long or clob |
binary(n) | if (n > 255) long raw else raw(n) |
varbinary(n) | if (n > 255) long raw else raw(n) |
long binary | long raw |