Result set data value conversion  Open Server-to-ODBC datatypes

Appendix B: Converting Datatypes

Data values sent to the client application

CHAR and VARCHAR datatype values shorter than the XNLCHAR and XNLVARCHAR values are returned to the client application as CS_CHAR. Datatype values longer than the XNLCHAR and XNLVARCHAR values, are returned as CS_TEXT.

A DECIMAL datatype is returned to the client application as CS_DECIMAL. Otherwise, the configuration settings shown in the DecimalResults configuration property applies.

For clients with System 10™ and earlier versions, DECIMAL data is returned as CS_FLOAT.





Copyright © 2005. Sybase Inc. All rights reserved. Open Server-to-ODBC datatypes

View this book as PDF