Data values received as parameters  Datatype names

Appendix B: Converting Datatypes

CS_DATAFMT usertype field values

The usertype field of the CS_DATAFMT structure is a 32-bit integer. The client application can specify a target DBMS datatype for a given column. The client application obtains the column datatype indicator from the REMOTE_DATA_TYPE column of the sp_columns result set.

The client application must place the value from sp_columns in the least-significant byte of the usertype field. The remainder of the value is ignored. If a value of 0 is used, the default conversion applies.

The user-defined datatype is used in the child process to transform the Open Server datatype to the ODBC datatype.





Copyright © 2005. Sybase Inc. All rights reserved. Datatype names

View this book as PDF