Item type properties
The following table lists the OLE DB data types and the values of the item type properties to which they correspond when the type tree is generated.
| OLE DB Data Type | Interpret as | Item Subclass, Presentation | Length |
|---|---|---|---|
| DBTYPE_UI1 | Character | Number, Integer | 3 |
| DBTYPE_UI2 | Character | Number, Integer | 5 |
| DBTYPE_UI4 | Character | Number, Integer | 10 |
| DBTYPE_UI8 | Character | Number, Integer | 20 |
| DBTYPE_I1 | Character | Number, Integer | 4 |
| DBTYPE_I2 | Character | Number, Integer | 6 |
| DBTYPE_I4 | Character | Number, Integer | 11 |
| DBTYPE_I8 | Character | Number, Integer | 20 |
| DBTYPE_R4 | Binary | Number, Float | 4 |
| DBTYPE_R8 | Binary | Number, Float | 8 |
| DBTYPE_CY | Character | Number, Decimal | * |
| DBTYPE_NUMERIC | Character | Number, Decimal | * |
| DBTYPE_BOOL | Character | Text (ASCII) | 1 |
| DBTYPE_STR | Character | Text (ASCII) | * |
| DBTYPE_WSTR | Character | Text (UNICODE) | * |
| DBTYPE_BYTES | Binary | Text (Byte stream) | * |
| DBTYPE_DBDATE | Character | Date & Time | 10 |
| DBTYPE_DBTIME | Character | Date & Time | 8 |
| DBTYPE_DBTIMESTAMP | Character | Date & Time | 19-26 |
* The DBMS dictates the length of this type.