Datatype Conversion

An access service converts data as ODBC-to-Open Server and Open Server-to-ODBC datatypes.

Limitations

The maximum size of data through ECDA Option for ODBC products is 32,767 bytes for all datatypes, including text and image.

A data size larger than 32,767 bytes is truncated.

Warning! ECDA Option for ODBC cannot correctly represent or transport varchar values containing empty strings (zero length non null strings). Empty string varchar values are represented as NULL values.

ODBC-to-Open Server Datatypes
When you retrieve data from the target database, the access service converts the target data to default Open Server datatypes for delivery to the client application.
Open Server-to-ODBC Datatypes
An access service converts or performs SQL transformation on incoming Open Server data it receives in a client request.
Microsoft SQL Server ODBC-Supported Datatypes
Supported Microsoft SQL Server datatypes and their corresponding ODBC datatypes.
DB2 UDB / ODBC-Supported Datatypes
Supported DB2 UDB datatypes and their related ODBC datatypes.

Created November 29, 2012. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com