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 |