Data type mappings between Db2 and OLE DB
The IBM® OLE DB Provider for Db2 supports data type mappings between Db2 data types and OLE DB data types.
The following table provides a complete list of supported mappings and available names for indicating the data types of columns and parameters.
| Db2 Data Types | OLE DB Data Types Indicators | OLE DB Standard Type Names | Db2 Specific Names |
|---|---|---|---|
| SMALLINT | DBTYPE_I2 | "DBTYPE_I2" | "SMALLINT" |
| INTEGER | DBTYPE_I4 | "DBTYPE_I4" | "INTEGER" or "INT" |
| BIGINT | DBTYPE_I8 | "DBTYPE_I8" | "BIGINT" |
| REAL | DBTYPE_R4 | "DBTYPE_R4" | "REAL" |
| FLOAT | DBTYPE_R8 | "DBTYPE_R8" | "FLOAT" |
| DOUBLE | DBTYPE_R8 | "DBTYPE_R8" | "DOUBLE" or "DOUBLE PRECISION" |
| DECIMAL | DBTYPE_NUMERIC | "DBTYPE_NUMERIC" | "DEC" or "DECIMAL" |
| NUMERIC | DBTYPE_NUMERIC | "DBTYPE_NUMERIC" | "NUM" or "NUMERIC" |
| DATE | DBTYPE_DBDATE | "DBTYPE_DBDATE" | "DATE" |
| TIME | DBTYPE_DBTIME | "DBTYPE_DBTIME" | "TIME" |
| TIMESTAMP | DBTYPE_DBTIMESTAMP | "DBTYPE_DBTIMESTAMP" | "TIMESTAMP" |
| CHAR | DBTYPE_STR | "DBTYPE_CHAR" | "CHAR" or "CHARACTER" |
| VARCHAR | DBTYPE_STR | "DBTYPE_VARCHAR" | "VARCHAR" |
| LONG VARCHAR | DBTYPE_STR | "DBTYPE_LONGVARCHAR" | "LONG VARCHAR" |
| CLOB |
DBTYPE_STR
and DBCOLUMNFLAGS_ISLONG or DBPARAMFLAGS_ISLONG |
"DBTYPE_CHAR"
"DBTYPE_VARCHAR" "DBTYPE_LONGVARCHAR" and DBCOLUMNFLAGS_ISLONG or DBPARAMFLAGS_ISLONG |
"CLOB" |
| GRAPHIC | DBTYPE_WSTR | "DBTYPE_WCHAR" | "GRAPHIC" |
| VARGRAPHIC | DBTYPE_WSTR | "DBTYPE_WVARCHAR" | "VARGRAPHIC" |
| LONG VARGRAPHIC | DBTYPE_WSTR | "DBTYPE_WLONGVARCHAR" | "LONG VARGRAPHIC" |
| DBCLOB |
DBTYPE_WSTR
and DBCOLUMNFLAGS_ISLONG or DBPARAMFLAGS_ISLONG |
"DBTYPE_WCHAR"
"DBTYPE_WVARCHAR" "DBTYPE_WLONGVARCHAR" and DBCOLUMNFLAGS_ISLONG or DBPARAMFLAGS_ISLONG |
"DBCLOB" |
| CHAR(n) FOR BIT DATA | DBTYPE_BYTES | "DBTYPE_BINARY" | |
| VARCHAR(n) FOR BIT DATA | DBTYPE_BYTES | "DBTYPE_VARBINARY" | |
| LONG VARCHAR FOR BIT DATA | DBTYPE_BYTES | "DBTYPE_LONGVARBINARY" | |
| BLOB |
DBTYPE_BYTES
and DBCOLUMNFLAGS_ISLONG or DBPARAMFLAGS_ISLONG |
"DBTYPE_BINARY"
"DBTYPE_VARBINARY" "DBTYPE_LONGVARBINARY" and DBCOLUMNFLAGS_ISLONG or DBPARAMFLAGS_ISLONG |
"BLOB" |