Sybase Open Client has its own internal data types, which differ in some details from those available in SAP Sybase IQ. For this reason, SAP Sybase IQ internally maps some data types between those used by Open Client applications and those available in SAP Sybase IQ.
To build Open Client applications, you need the development version of Open Client. To use Open Client applications, the Open Client run-times must be installed and configured on the computer where the application runs.
The SAP Sybase IQ server does not require any external communications runtime to support Open Client applications.
Each Open Client data type is mapped onto the equivalent SAP Sybase IQ data type. All Open Client data types are supported.
The following table lists the mappings of data types supported in SAP Sybase IQ that have no direct counterpart in Open Client.
| SAP Sybase IQ data type | Open Client data type |
|---|---|
| unsigned short | int |
| unsigned int | bigint |
| unsigned bigint | numeric(20,0) |
| string | varchar |
| timestamp | datetime |