Sybase Open Client has its own internal data types, which differ in some details from those available in SQL Anywhere. For this reason, SQL Anywhere internally maps some data types between those used by Open Client applications and those available in SQL 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 SQL Anywhere server does not require any external communications runtime to support Open Client applications.
Each Open Client data type is mapped onto the equivalent SQL Anywhere data type. All Open Client data types are supported
The following table lists the mappings of data types supported in SQL Anywhere that have no direct counterpart in Open Client.
SQL Anywhere data type | Open Client data type |
---|---|
unsigned short | int |
unsigned int | bigint |
unsigned bigint | numeric(20,0) |
date | smalldatetime |
time | smalldatetime |
string | varchar |
timestamp | datetime |
Range limitations in data type mapping
Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |