ODBC标准数据类型与C数据类型绑定
数据库数据类型，ODBC SQL通用数据类型，以及他们与C语言数据类型绑定时的映射关系信息如表1所示。
| 虚谷数据库数据类型 | ODBC SQL公共数据类型 | ODBC 绑定的C映射的数据类 |
|---|---|---|
| Char(n) | SQL_CHAR | SQL_C_CHAR |
| Varchar(n) | SQL_CHAR | SQL_C_CHAR |
| Binary(n) | SQL_BINARY | SQL_C_BINARY |
| Tinyint | SQL_TINYINT | SQL_C_TINYINT |
| Smallint | SQL_SMALLINT | SQL_C_SHORT |
| Integer | SQL_INTEGER | SQL_C_LONG |
| Bigint | SQL_BIGINT | SQL_C_SBIGINT |
| Float | SQL_FLOAT | SQL_C_FLOAT |
| Double | SQL_DOUBLE | SQL_C_DOUBLE |
| Bool | SQL_TINYINT、SQLCHAR | SQL_C_TINYINT/SQL_C_CHAR |
| Numeric(p,s) | SQL_NUMERIC | SQL_C_NUMERIC/SQL_C_CHAR |
| Time | SQL_TIME | SQL_C_TIME/SQL_C_TYPE_TIME/SQL_C_CHAR |
| Datetime | SQL_DATETIME | SQL_C_TIMESTAMP/SQL_C_TYPE_TIMESTAMP/SQL_C_CHAR |
| Date | SQL_DATE | SQL_C_DATE/SQL_C_TYPE_DATE/SQL_C_CHAR |
| Time with time zone | SQL_CHAR | SQL_C_CHAR |
| Datetime with time zone | SQL_CHAR | SQL_C_CHAR |
| Blob | SQL_LONGVARBINARY | SQL_C_BINARY |
| Clob | SQL_LONGVARCHAR | SQL_C_CHAR |
| Interval year | SQL_INTERVAL_YEAR | SQL_C_INTERVAL_YEAR/SQL_C_CHAR |
| Interval month | SQL_INTERVAL_MONTH | SQL_C_INTERVAL_MONTH/SQL_C_CHAR |
| Interval day | SQL_INTERVAL_DAY | SQL_C_INTERVAL_DAY/SQL_C_CHAR |
| Interval hour | SQL_INTERVAL_HOUR | SQL_C_INTERVAL_HOUR/SQL_C_CHAR |
| Interval minute | SQL_INTERVAL_MINUTE | SQL_C_INTERVAL_MINUTE/SQL_C_CHAR |
| Interval second | SQL_INTERVAL_SECOND | SQL_C_INTERVAL_SECOND/SQL_C_CHAR |
| Interval day to hour | SQL_INTERVAL_DAY_TO_HOUR | SQL_C_INTERVAL_DAY_TO_HOUR/SQL_C_CHAR |
| Interval day to minute | SQL_INTERVAL_DAY_TO_MINUTE | SQL_C_INTERVAL_DAY_TO_MINUTE/SQL_C_CHAR |
| Interval day to second | SQL_INTERVAL_DAY_TO_SECOND | SQL_C_INTERVAL_DAY_TO_SECOND/SQL_C_CHAR |
| Interval hour to minute | SQL_INTERVAL_HOUR_TO_MINUTE | SQL_C_INTERVAL_HOUR_TO_MINUTE/SQL_C_CHAR |
| Interval hour to second | SQL_INTERVAL_HOUR_TO_SECOND | SQL_C_INTERVAL_HOUR_TO_SECOND/SQL_C_CHAR |
| Interval minute to second | SQL_INTERVAL_MINUTE_TO_SECOND | SQL_C_INTERVAL_MINUTE_TO_SECOND/SQL_C_CHAR |
| Interval year to month | SQL_INTERVAL_YEAR_TO_MONTH | SQL_C_INTERVAL_YEAR_TO_MONTH/SQL_C_CHAR |