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