Type Indicators in a Microsoft Access Provider
This table shows how a Microsoft Access provider might map its data types to OLE DB data types.
Microsoft Access data type |
OLE DB type indicator |
|---|---|
BINARY (< 255 bytes) |
DBTYPE_BYTES |
BIT |
DBTYPE_BOOL |
BYTE |
DBTYPE_UI1 |
COUNTER |
DBTYPE_I4 |
CURRENCY |
DBTYPE_CY |
DATETIME |
DBTYPE_DATE |
DOUBLE |
DBTYPE_R8 |
GUID |
DBTYPE_GUID |
LONG |
DBTYPE_I4 |
LONGBINARY |
DBTYPE_BYTES |
LONGTEXT |
DBTYPE_STR |
SHORT |
DBTYPE_I2 |
SINGLE |
DBTYPE_R4 |
TEXT (< 255 bytes) |
DBTYPE_STR |