Nonstop Database, HiRDB Version 9 UAP Development Guide
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 |
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.