ADO::DataTypeEnum

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.