15.3.2 Correspondence between ODBC's SQL data types and C data types
The following tables show the correspondence between ODBC's SQL data types and C data types in terms of the combinations of data types that can be compared and stored or assigned, and the combinations of data types that can be retrieved.
- Legend:
-
D: Default conversion or recommended combination.
Y: Can be converted. However, data truncation or precision loss might occur during conversion.
--: Cannot be converted.
- Legend:
-
D: Default conversion or recommended combination.
Y: Can be converted. However, data truncation or precision loss might occur during conversion.
--: Cannot be converted.
- #
-
If ACCESS is specified in the ADBODBAPMODE environment variable, the default conversion will be SQL_C_CHAR.