ASA SQL User's Guide
Server Classes for Remote Data Access
JDBC-based server classes
Server class asejdbc
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 | ASE 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) |