The following table shows the correspondences between the HiRDB data types and the OLE DB type indicators.

Table 15-2 Correspondences between the HiRDB data types and the OLE DB type indicators

HiRDB data types	OLE DB type indicators
CHAR, MCHAR, and NCHAR	DBTYPE_STR
VARCHAR, MVARCHAR, and NVARCHAR
DECIMAL(p,s)	DBTYPE_NUMERIC
SMALLINT (signed)	DBTYPE_I2
INTEGER (signed)	DBTYPE_I4
REAL	DBTYPE_R4
SMALLFLT
FLOAT	DBTYPE_R8
DOUBLE PRECISION
BLOB	DBTYPE_BYTES
BINARY
DATE	DBTYPE_DBDATE
TIME	DBTYPE_DBTIME
TIMESTAMP	DBTYPE_DBTIMESTAMP
INTERVAL YEAR TO DAY	DBTYPE_DECIMAL
INTERVAL HOUR TO SECOND	DBTYPE_DECIMAL