The Local Type represents the OLE DB data type used for this column on the PC. The OLE DB data types are defined in the OLE DB specifications and #defines can be found in the OLEDB.H include file. The allowable values for Local Type that can be selected from the drop-down list box include the following:
Host Type | Description |
---|---|
DBTYPE_BYTES | Fixed-length binary data represented as an unsigned char array. |
DBTYPE_DBDATE | The OLE DB DBDATE typedef struct as defined in the OLEDB.H header file. |
DBTYPE_DECIMAL | The OLE DB DECIMAL typedef struct as defined in the OLEDB.H header file. |
DBTYPE_NUMERIC | The OLE DB NUMERIC typedef struct as defined in the OLEDB.H header file. |
DBTYPE_I2 | Integer data stored in 2 bytes (16 bits). |
DBTYPE_I4 | Integer data stored in 4 bytes (32 bits). |
DBTYPE_R4 | Single precision IEEE floating-point data stored in 4 bytes (32 bits). |
DBTYPE_R8 | Double precision floating-point data stored in 8 bytes (64 bits). |
DBTYPE_STR | Fixed and variable length character data. |
DBTYPE_DBTIME | The OLE DB DBTIME typedef as defined in the OLEDB.H header file. |
DBTYPE_DBTIMESTAMP | The OLE DB DBTIMESTAMP typedef struct as defined in the OLEDB.H header file. |