MobiLink Synchronization Reference
DataType Conversions
The following table identifies how Adaptive Server Anywhere data types are mapped to Oracle data types.
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(10,4) |
money | number(19,4) |
date | date |
time | date |
timestamp | date |
smalldatetime | date |
datetime | date |
char(n) | varchar(n) or CLOB(n) |
varchar(n) | varchar(n) or CLOB(n) |
long varchar | CLOB |
binary(n) | raw(n) or BLOB(n) |
varbinary(n) | raw(n) or BLOB(n) |
long binary | BLOB |
The LONG data types are deprecated in Oracle 8, 8i and 9i.
For Oracle LONG data types to synchronize properly, you must check the Oracle Force Retrieval of Long Columns ODBC option in the ODBC data source configuration dialog.