MobiLink Synchronization Reference
DataType Conversions
The following table identifies how Adaptive Server Anywhere data types are mapped to Adaptive Server Enterprise data types.
| Adaptive Server Anywhere data type | Adaptive Server Enterprise data type |
|---|---|
| bit | bit |
| tinyint | tinyint |
| smallint | smallint |
| int | int |
| integer | integer |
| decimal [defaults p=30, s=6] | numeric(30,6) |
| numeric [defaults p=30 s=6] | numeric(30,6) |
| float | real |
| real | real |
| double | float |
| smallmoney | numeric(10,4) |
| money | numeric(19,4) |
| date | datetime |
| time | datetime |
| timestamp | datetime |
| smalldatetime | datetime |
| datetime | datetime |
| char(n) | varchar(n) |
| character(n) | varchar(n) |
| varchar(n) | varchar(n) |
| character varying(n) | varchar(n) |
| long varchar | text |
| text | text |
| binary(n) | binary(n) |
| long binary | image |
| image | image |
| bigint | numeric(20,0) |