ADO Client
- Last Updated: May 12, 2026
- 1 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
The following table lists the data types that the ADO Client supports for the OpenAccess SDK SQL engine or a third-party SQL engine:
Mapping OpenAccess SDK Data Types to ADO Data Types
| OpenAccess Data Type | OLE DB Data Type |
| BIGINT | DBTYPE_I8 |
| BINARY | DBTYPE_BYTES |
| BIT | DBTYPE_BOOL |
| CHAR | DBTYPE_STR |
| DATE | DBTYPE_DBDATE |
| DOUBLE | DBTYPE_R8 |
| FLOAT | DBTYPE_R8 |
| INTEGER | DBTYPE_I4 |
| LONGVARBINARY | DBTYPE_BYTES |
| LONGVARCHAR | DBTYPE_BYTES |
| NUMERIC | DBTYPE_NUMERIC |
| REAL | DBTYPE_R4 |
| SMALLINT | DBTYPE_I2 |
| TIME | DBTYPE_DBTIME |
| TIMESTAMP | DBTYPE_TIMESTAMP1DBTYPE_STR2 |
| TINYINT | DBTYPE_UI1 |
| VARBINARY | DBTYPE_BYTES |
| VARCHAR | DBTYPE_STR |
| WCHAR | DBTYPE_STR |
| WLONGVARCHAR | DBTYPE_STR |
1 Only present when DataSourceFetchTimestampAsString=False
2 Only present when DataSourceFetchTimestampAsString=True