10. Understanding ODBC Connectivity : ODBC Programming : Transactions Handling : Supported Data Types
 
Share this page                  
Supported Data Types
The ODBC Driver supports all ODBC data types except:
• SQL_GUID and SQL_C_GUID
• SQL_BOOKMARK and SQL_C_BOOKMARK
• SQL_VARBOOKMARK and SQL_C_VARBOOKMARK
The ODBC function SQLBindParameter() allows coercion from "C" data types to SQL data types. Outside of the above exceptions, the ODBC supports all ODBC data type coercions as described in the "Converting Data from SQL to C Data Types" and "Converting Data from C to SQL Data Types" tables in the Microsoft ODBC Programmer's Reference. The following table summarizes the coercions available:
Data Type
SQL Type
String
All types
Binary
All types
Numeric
All numeric
Timestamp, date and time
Timestamp, date and time
Interval
Interval