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.

Table 15‒4: Combinations of data types that can be compared and stored or assigned (conversion from C data types to ODBC's SQL data types)

Legend:

D: Default conversion or recommended combination.

Y: Can be converted. However, data truncation or precision loss might occur during conversion.

--: Cannot be converted.

Table 15‒5: Combinations of data types that can be retrieved (conversion from ODBC's SQL data types to C data types)

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.

To Page Top