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 |