ODBC Client
- Last Updated: May 12, 2026
- 1 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
The following table lists the data types that the ODBC Client supports for the OpenAccess SDK SQL engine or a third-party SQL engine:
Mapping OpenAccess SDK Data Types to ODBC Data Types
| OpenAccess Server Data Type | ODBC Data Type |
|---|---|
| BIGINT | SQL_BIGINT |
| BINARY | SQL_BINARY |
| BIT | SQL_BIT |
| CHAR | SQL_CHAR |
| DATE | SQL_DATE |
| DOUBLE | SQL_DOUBLE |
| FLOAT | SQL_FLOAT |
| INTEGER | SQL_INTEGER |
| LONGVARBINARY | SQL_LONGVARBINARY |
| NUMERIC | SQL_VARCHAR |
| REAL | SQL_REAL |
| SMALLINT | SQL_SMALLINT |
| TIME | SQL_TIME |
| TIMESTAMP | SQL_TIMESTAMP |
| TINYINT | SQL_TINYINT |
| VARBINARY | SQL_VARBINARY |
| VARCHAR | SQL_VARCHAR |
| WCHAR | SQL_WCHAR |
| WLONGVARCHAR | SQL_WLONGVARCHAR |
| WVARCHAR | SQL_WVARCHAR |