Unfortunately, some providers may not support all of the possible data types. If a provider encounters a data type that it does not recognize, it will usually change it to a data type that it does recognize.
Constant
| Value
| Description
|
adArray
| 0x2000
| Combine with another data type to indicate that the other data type is an array
|
adBigInt
| 20
| 8-byte signed integer
|
adBinary
| 128
| Binary
|
adBoolean
| 11
| True or false Boolean
|
adBSTR
| 8
| Null-terminated character string
|
adChapter
| 136
| 4-byte chapter value for a child recordset
|
adChar
| 129
| String
|
adCurrency
| 6
| Currency format
|
adDate
| 7
| Number of days since 12/30/1899
|
adDBDate
| 133
| YYYYMMDD date format
|
adDBFileTime
| 137
| Database file time
|
adDBTime
| 134
| HHMMSS time format
|
adDBTimeStamp
| 135
| YYYYMMDDHHMMSS date/time format
|
adDecimal
| 14
| Number with fixed precision and scale
|
adDouble
| 5
| Double precision floating-point
|
adEmpty
| 0
| no value
|
adError
| 10
| 32-bit error code
|
adFileTime
| 64
| Number of 100-nanosecond intervals since 1/1/1601
|
adGUID
| 72
| Globally Unique identifier
|
adIDispatch
| 9
| Currently not supported by ADO
|
adInteger
| 3
| 4-byte signed integer
|
adIUnknown
| 13
| Currently not supported by ADO
|
adLongVarBinary
| 205
| Long binary value
|
adLongVarChar
| 201
| Long string value
|
adLongVarWChar
| 203
| Long Null-terminates string value
|
adNumeric
| 131
| Number with fixed precision and scale
|
adPropVariant
| 138
| PROPVARIANT automation
|
adSingle
| 4
| Single-precision floating-point value
|
adSmallInt
| 2
| 2-byte signed integer
|
adTinyInt
| 16
| 1-byte signed integer
|
adUnsignedBigInt
| 21
| 8-byte unsigned integer
|
adUnsignedInt
| 19
| 4-byte unsigned integer
|
adUnsignedSmallInt
| 18
| 2-byte unsigned integer
|
adUnsignedTinyInt
| 17
| 1-byte unsigned integer
|
adUserDefined
| 132
| User-defined variable
|
adVarBinary
| 204
| Binary value
|
adVarChar
| 200
| String
|
adVariant
| 12
| Automation variant
|
adVarNumeric
| 139
| Variable width exact numeric with signed scale
|
adVarWChar
| 202
| Null-terminated Unicode character string
|
adWChar
| 130
| Null-terminated Unicode character string
|