14.4 Data type correspondences

Table 14-2 shows the correspondences between the HiRDB data types and the OLE DB type indicators.

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

HiRDB data typesOLE DB type indicators
CHAR, MCHAR, and NCHARDBTYPE_STR
VARCHAR, MVARCHAR, and NVARCHAR
DECIMAL(p,s)DBTYPE_NUMERIC
SMALLINT (signed)DBTYPE_I2
INTEGER (signed)DBTYPE_I4
REALDBTYPE_R4
SMALLFLT
FLOATDBTYPE_R8
DOUBLE PRECISION
BLOBDBTYPE_BYTES
BINARY
DATEDBTYPE_DBDATE
TIMEDBTYPE_DBTIME
TIMESTAMPDBTYPE_DBTIMESTAMP
INTERVAL YEAR TO DAYDBTYPE_DECIMAL
INTERVAL HOUR TO SECONDDBTYPE_DECIMAL