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).