14.4 データ型の対応
HiRDBのデータ型とOLE DB型標識の対応を次の表に示します。
HiRDBのデータ型 |
OLE DB型標識 |
---|---|
CHAR,MCHAR,及びNCHAR |
DBTYPE_STR |
VARCHAR,MVARCHAR,及び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 |