2010.05.06 00:00
DataTypeEnum
Specifies the data type of a Field, Parameter, or Property. The corresponding OLE DB type indicator is shown in parentheses in the description column of the following table.
For more information about OLE DB data types, see Data Types in OLE DB (OLE DB), and Appendix A: Data Types of the OLE DB Programmer's Guide.
| Constant | Value | Description |
| AdArray | 0x2000 | A flag value, always combined with another data type constant, that indicates an array of the other data type. Does not apply to ADOX. |
| adBigInt | 20 | Indicates an eight-byte signed integer (DBTYPE_I8). |
| adBinary | 128 | Indicates a binary value (DBTYPE_BYTES). |
| adBoolean | 11 | Indicates a Boolean value (DBTYPE_BOOL). |
| adBSTR | 8 | Indicates a null-terminated character string (Unicode) (DBTYPE_BSTR). |
| adChapter | 136 | Indicates a four-byte chapter value that identifies rows in a child rowset (DBTYPE_HCHAPTER). |
| adChar | 129 | Indicates a string value (DBTYPE_STR). |
| adCurrency | 6 | Indicates a currency value (DBTYPE_CY). Currency is a fixed-point number with four digits to the right of the decimal point. It is stored in an eight-byte signed integer scaled by 10,000. |
| adDate | 7 | Indicates a date value (DBTYPE_DATE). A date is stored as a double, the whole part of which is the number of days since December 30, 1899, and the fractional part of which is the fraction of a day. |
| adDBDate | 133 | Indicates a date value (yyyymmdd) (DBTYPE_DBDATE). |
| adDBTime | 134 | Indicates a time value (hhmmss) (DBTYPE_DBTIME). |
| adDBTimeStamp | 135 | Indicates a date/time stamp (yyyymmddhhmmss plus a fraction in billionths) (DBTYPE_DBTIMESTAMP). |
| adDecimal | 14 | Indicates an exact numeric value with a fixed precision and scale (DBTYPE_DECIMAL). |
| adDouble | 5 | Indicates a double-precision floating-point value (DBTYPE_R8). |
| adEmpty | 0 | Specifies no value (DBTYPE_EMPTY). |
| adError | 10 | Indicates a 32-bit error code (DBTYPE_ERROR). |
| adFileTime | 64 | Indicates a 64-bit value representing the number of 100-nanosecond intervals since January 1, 1601 (DBTYPE_FILETIME). |
| adGUID | 72 | Indicates a globally unique identifier (GUID) (DBTYPE_GUID). |
| adIDispatch | 9 | Indicates a pointer to an IDispatch interface on a COM object (DBTYPE_IDISPATCH). Note This data type is currently not supported by ADO. Usage may cause unpredictable results. |
| adInteger | 3 | Indicates a four-byte signed integer (DBTYPE_I4). |
| adIUnknown | 13 | Indicates a pointer to an IUnknown interface on a COM object (DBTYPE_IUNKNOWN). Note This data type is currently not supported by ADO. Usage may cause unpredictable results. |
| adLongVarBinary | 205 | Indicates a long binary value. |
| adLongVarChar | 201 | Indicates a long string value. |
| adLongVarWChar | 203 | Indicates a long null-terminated Unicode string value. |
| adNumeric | 131 | Indicates an exact numeric value with a fixed precision and scale (DBTYPE_NUMERIC). |
| adPropVariant | 138 | Indicates an Automation PROPVARIANT (DBTYPE_PROP_VARIANT). |
| adSingle | 4 | Indicates a single-precision floating-point value (DBTYPE_R4). |
| adSmallInt | 2 | Indicates a two-byte signed integer (DBTYPE_I2). |
| adTinyInt | 16 | Indicates a one-byte signed integer (DBTYPE_I1). |
| adUnsignedBigInt | 21 | Indicates an eight-byte unsigned integer (DBTYPE_UI8). |
| adUnsignedInt | 19 | Indicates a four-byte unsigned integer (DBTYPE_UI4). |
| adUnsignedSmallInt | 18 | Indicates a two-byte unsigned integer (DBTYPE_UI2). |
| adUnsignedTinyInt | 17 | Indicates a one-byte unsigned integer (DBTYPE_UI1). |
| adUserDefined | 132 | Indicates a user-defined variable (DBTYPE_UDT). |
| adVarBinary | 204 | Indicates a binary value. |
| adVarChar | 200 | Indicates a string value. |
| adVariant | 12 | Indicates an Automation Variant (DBTYPE_VARIANT). Note This data type is currently not supported by ADO. Usage may cause unpredictable results. |
| adVarNumeric | 139 | Indicates a numeric value. |
| adVarWChar | 202 | Indicates a null-terminated Unicode character string. |
| adWChar | 130 | Indicates a null-terminated Unicode character string (DBTYPE_WSTR). |