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 |