skip to main content
Data Types Supported : Supported Data Types : ADO Client
 

ADO Client

The following table lists the data types that the ADO Client supports for the OpenAccess SDK SQL engine or a third-party SQL engine:
Table 42: 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_TIMESTAMP1
DBTYPE_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