Appendix B: Converting Datatypes
Microsoft SQL Server ODBC-supported
datatypes
The following table identifies the supported Microsoft SQL
Server datatypes and their corresponding ODBC datatypes.
Table B-3: Microsoft
SQL datatypes and related ODBC datatypes
Microsoft SQL Server datatypes
|
ODBC datatypes
|
DATE
|
SQL_TYPE_DATE(91)
|
CHAR
|
SQL_WCHAR(1)
|
NUMERIC
|
SQL_WNUMERIC(2)
|
DECIMAL
|
SQL_WDECIMAL(3)
|
MONEY
|
SQL_WDECIMAL(3)
|
SMALLMONEY
|
SQL_WDECIMAL(3)
|
INT
|
SQL_WINTEGER(4)
|
SMALLINT
|
SQL_WSMALLINT(5)
|
FLOAT
|
SQL_WFLOAT(6)
|
REAL
|
SQL_WREAL(7)
|
VARCHAR
|
SQL_WVARCHAR(12)
|
TEXT
|
SQL_WLONGVARCHAR(-1)
|
TIMESTAMP
|
SQL_WBINARY(-2)
|
BINARY
|
SQL_WBINARY(-2)
|
VARBINARY
|
SQL_WVARBINARY(-3)
|
IMAGE
|
SQL_WLONGVARBINARY(-4)
|
TINYINT
|
SQL_WTINYINT(-6)
|
BIT
|
SQL_WBIT(-7)
|
* NCHAR
|
SQL_WCHAR(-8)
|
* NVARCHAR
|
SQL_WVARCHAR(-9)
|
* NTEXT
|
SQL_WLONGVARBINARY(-10)
|
TIMESTAMP
|
SQL_TYPE_TIMESTAMP(93)
|
DATETIME
|
SQL_TYPE_WTIMESTAMP(93)
|
SMALL DATETIME
|
SQL_TYPE_WTIMESTAMP(93)
|
* These datatypes are converted to single-byte ASCII.
Future support is anticipated.
Copyright © 2005. Sybase Inc. All rights reserved.
|
|
View this book as PDF