Appendix B: Converting Datatypes
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. The following
table shows ODBC datatypes and the resulting Open Server datatypes.
Table B-1: ODBC to Open Server datatype
mapping
ODBC datatype
|
Open Server datatype
|
SQL_CHAR
|
CS_CHAR
|
SQL_VARCHAR
|
CS_VARCHAR
|
SQL_LONGVARCHAR
|
CS_TEXT
|
SQL_DECIMAL
|
CS_DECIMAL
|
SQL_NUMERIC
|
CS_NUMERIC
|
SQL_SMALLINT
|
CS_SMALLINT
|
SQL_INTEGER
|
CS_INTEGER
|
SQL_REAL
|
CS_REAL
|
SQL_FLOAT
|
CS_FLOAT
|
SQL_DOUBLE
|
CS_FLOAT
|
SQL_BIT
|
CS_BIT
|
SQL_TINYINT
|
CS_TINYINT
|
SQL_BIGINT
|
CS_NUMERIC
|
SQL_BINARY
|
CS_BINARY
|
SQL_VARBINARY
|
CS_VARBINARY
|
SQL_LONGVARBINARY
|
CS_IMAGE
|
SQL_DATE
|
CS_CHAR
|
SQL_TIME
|
CS_CHAR
|
SQL_TIMESTAMP
|
CS_CHAR
|
SQL_INTERVAL
|
CS_CHAR
|
Copyright © 2005. Sybase Inc. All rights reserved.
|
|
View this book as PDF