Contents Index IBM DB2 Microsoft SQL Server

MobiLink Synchronization Reference
  DataType Conversions

Oracle


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.


Contents Index IBM DB2 Microsoft SQL Server