ASA SQL User's Guide
Server Classes for Remote Data Access
ODBC-based server classes
Server class aseodbc
When you issue a CREATE TABLE statement, Adaptive Server Anywhere automatically converts the data types to the corresponding Adaptive Server Enterprise data types. The following table describes the Adaptive Server Anywhere to Adaptive Server Enterprise data type conversions.
Adaptive Server Anywhere data type | Adaptive Server Enterprise default data type |
---|---|
Bit | bit |
Tinyint | tinyint |
Smallint | smallint |
Int | int |
Integer | integer |
decimal [defaults p=30, s=6] | numeric(30,6) |
decimal(128,128) | not supported |
numeric [defaults p=30 s=6] | numeric(30,6) |
numeric(128,128) | not supported |
Float | real |
Real | real |
Double | float |
Smallmoney | numeric(10,4) |
Money | numeric(19,4) |
Date | datetime |
Time | datetime |
Timestamp | datetime |
Smalldatetime | datetime |
Datetime | datetime |
char(n) | varchar(n) |
Character(n) | varchar(n) |
varchar(n) | varchar(n) |
Character varying(n) | varchar(n) |
long varchar | text |
Text | text |
binary(n) | binary(n) |
long binary | image |
Image | image |
Bigint | numeric(20,0) |