ADO::DataTypeEnum
Specifies the data type of a Field, or Property.
| Constant |
Value |
Description |
adBoolean |
11 |
Indicates a boolean value. |
adBSTR |
8 |
Indicates a null-terminated character string (Unicode). |
adChar |
129 |
Indicates a string value. |
adCurrency |
6 |
Indicates a currency value. 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. 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. |
adDecimal |
14 |
Indicates an exact numeric value with a fixed precision and scale. |
adDouble |
5 |
Indicates a double-precision floating-point value. |
adEmpty |
0 |
Specifies no value. |
adInteger |
3 |
Indicates a four-byte signed integer. |
| adGUID |
72 |
Indicates a globally unique identifier (GUID). |
adLongVarWChar |
203 |
Indicates a long null-terminated Unicode string value. |
adNumeric |
131 |
Indicates an exact numeric value with a fixed precision and scale. |
adSingle |
4 |
Indicates a single-precision floating-point value. |
adSmallInt |
2 |
Indicates a two-byte signed integer. |
adTinyInt |
16 |
Indicates a one-byte signed integer. |
adUnsignedInt |
19 |
Indicates a four-byte unsigned integer. |
adUnsignedSmallInt |
18 |
Indicates a two-byte unsigned integer. |
adUnsignedTinyInt |
17 |
Indicates a one-byte unsigned integer. |
adUserDefined |
132 |
Indicates a user-defined variable. |
adVarBinary |
204 |
Indicates a binary value. |
adVarChar |
200 |
Indicates a string value. |
adVarNumeric |
139 |
Indicates a numeric value. |
adVarWChar |
202 |
Indicates a null-terminated Unicode character string. |
adWChar |
130 |
Indicates a null-terminated Unicode character string. |
|