ASA Programming Guide
The Open Client Interface
Open Client has its own internal data types, which differ in some details from those available in Adaptive Server Anywhere. For this reason, Adaptive Server Anywhere internally maps some data types between those used by Open Client applications and those available in Adaptive Server Anywhere.
To build Open Client applications, you need the development version of Open Client. To use Open Client applications, the Open Client runtimes must be installed and configured on the computer where the application runs.
The Adaptive Server Anywhere server does not require any external communications runtime in order to support Open Client applications.
Each Open Client data type is mapped onto the equivalent Adaptive Server Anywhere data type. All Open Client data types are supported
The following table lists the mappings of data types supported in Adaptive Server Anywhere that have no direct counterpart in Open Client.
| ASA data type | Open Client data type |
|---|---|
| unsigned short | int |
| unsigned int | bigint |
| unsigned bigint | bigint |
| date | smalldatetime |
| time | smalldatetime |
| serialization | longbinary |
| string | varchar |
| timestamp struct | datetime |
Range limitations in data type mapping