Contents Index Sybase Adaptive Server Enterprise Oracle

MobiLink Synchronization Reference
  DataType Conversions

IBM DB2


The following table identifies how Adaptive Server Anywhere data types are mapped to IBM DB2 data types.

Adaptive Server Anywhere data type IBM DB2 data type
bit smallint
tinyint smallint
smallint smallint
int int
integer int
bigint decimal(20,0)
char(1-4000) varchar(n)
char(4001-32767) long varchar
character(1-4000) varchar(n)
character(4001-32767) long varchar
varchar(1-4000) varchar(n)
varchar(4001-32767) long varchar
character varying(1-4000) varchar(n)
character varying(4001-32767) long varchar or CLOB(n)
long varchar long varchar or CLOB(n)
text long varchar
binary(1-4000) varchar for bit data or BLOB(n)
binary(4001-32767) long varchar for bit data or BLOB(n)
long binary long varchar for bit data or BLOB(n)
image long varchar for bit data or BLOB(n)
decimal [defaults p=30, s=6] decimal(30,6)
numeric [defaults p=30 s=6] decimal(30,6)
real real
float float
double float
smallmoney decimal(10,4)
money decimal(19,4)
date date
time time
smalldatetime timestamp
datetime timestamp
timestamp timestamp

Contents Index Sybase Adaptive Server Enterprise Oracle