ODBC-to-Open Server datatypes  Data values sent to the client application

Appendix B: Converting Datatypes

Result set data value conversion

Data values returned from the target DBMS to a client application are converted into a format that Open Client and Open Server can handle. This conversion can encounter inconsistencies, particularly in supported ranges. The access service must convert the value from the target into a matching Open Client and Open Server datatype before it sends the value back to the client.

To do this, the access service uses configuration properties. Each target datatype has a default Open Client and Open Server mapping, but these may be overridden either by the configuration property (thus affecting the entire service) or through a set statement (thus affecting only the client connection).

For more information on configuration values that affect data conversion, see “Data conversion error properties”.





Copyright © 2005. Sybase Inc. All rights reserved. Data values sent to the client application

View this book as PDF