MobiLink Synchronization Reference
DataType Conversions
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 |