|
odtEmpty
|
No value (DBTYPE_EMPTY).
|
|
odtSmallInt
|
A 16-bit signed integer (DBTYPE_I2). This maps to Int16.
|
|
odtInteger
|
A 32-bit signed integer (DBTYPE_I4). This maps to Int32.
|
|
odtSingle
|
A floating-point number within the range of -3.40E +38 through 3.40E +38 (DBTYPE_R4). This maps to Single.
|
|
odtDouble
|
A floating-point number within the range of -1.79E +308 through 1.79E +308 (DBTYPE_R8). This maps to Double.
|
|
odtCurrency
|
A currency value ranging from -2 63 (or -922,337,203,685,477.5808) to 2 63 -1 (or +922,337,203,685,477.5807) with an accuracy to a ten-thousandth of a currency unit (DBTYPE_CY). This maps to Decimal.
|
|
odtDate
|
Date data, stored as a double (DBTYPE_DATE). The whole portion is the number of days since December 30, 1899, and the fractional portion is a fraction of a day. This maps to DateTime.
|
|
odtBSTR
|
A null-terminated character string of Unicode characters (DBTYPE_BSTR). This maps to String.
|
|
odtIDispatch
|
A pointer to an IDispatch interface (DBTYPE_IDISPATCH). This maps to variant.
|
|
odtError
|
A 32-bit error code (DBTYPE_ERROR). This maps to Exception.
|
|
odtBoolean
|
A Boolean value (DBTYPE_BOOL). This maps to Boolean.
|
|
odtVariant
|
A special data type that can contain numeric, string, binary, or date data, and also the special values Empty and Null (DBTYPE_VARIANT). This type is assumed if no other is specified.
|
|
odtIUnknown
|
A pointer to an IUnknown interface (DBTYPE_UNKNOWN). This maps to variant.
|
|
odtDecimal
|
A fixed precision and scale numeric value between -10 38 -1 and 10 38 -1 (DBTYPE_DECIMAL). This maps to Decimal.
|
|
odtTinyInt
|
A 8-bit signed integer (DBTYPE_I1). This maps to SByte.
|
|
odtUnsignedTinyInt
|
A 8-bit unsigned integer (DBTYPE_UI1). This maps to Byte.
|
|
odtUnsignedSmallInt
|
A 16-bit unsigned integer (DBTYPE_UI2). This maps to UInt16.
|
|
odtUnsignedInt
|
A 32-bit unsigned integer (DBTYPE_UI4). This maps to UInt32.
|
|
odtBigInt
|
A 64-bit signed integer (DBTYPE_I8). This maps to Int64.
|
|
odtUnsignedBigInt
|
A 64-bit unsigned integer (DBTYPE_UI8). This maps to UInt64.
|
|
odtFiletime
|
A 64-bit unsigned integer representing the number of 100-nanosecond intervals since January 1, 1601 (DBTYPE_FILETIME). This maps to DateTime.
|
|
odtGuid
|
A globally unique identifier (or GUID) (DBTYPE_GUID). This maps to Guid.
|
|
odtBinary
|
A stream of binary data (DBTYPE_BYTES). This maps to an Array of type Byte.
|
|
odtChar
|
A character string (DBTYPE_STR). This maps to String.
|
|
odtWChar
|
A null-terminated stream of Unicode characters (DBTYPE_WSTR). This maps to String.
|
|
odtNumeric
|
An exact numeric value with a fixed precision and scale (DBTYPE_NUMERIC). This maps to Decimal.
|
|
odtDBDate
|
Date data in the format yyyymmdd (DBTYPE_DBDATE). This maps to DateTime.
|
|
odtDBTime
|
Time data in the format hhmmss (DBTYPE_DBTIME). This maps to TimeSpan.
|
|
odtDBTimeStamp
|
Data and time data in the format yyyymmddhhmmss (DBTYPE_DBTIMESTAMP). This maps to DateTime.
|
|
odtPropVariant
|
An automation PROPVARIANT (DBTYPE_PROP_VARIANT). This maps to variant.
|
|
odtVarNumeric
|
A variable-length numeric value (OleDbParameter only). This maps to Decimal.
|
|
odtVarChar
|
A variable-length stream of non-Unicode characters (OleDbParameter only). This maps to String.
|
|
odtLongVarChar
|
A long string value (OleDbParameter only). This maps to String.
|
|
odtVarWChar
|
A variable-length, null-terminated stream of Unicode characters (OleDbParameter only). This maps to String.
|
|
odtLongVarWChar
|
A long null-terminated Unicode string value (OleDbParameter only). This maps to String.
|
|
odtVarBinary
|
A variable-length stream of binary data (OleDbParameter only). This maps to an Array of type Byte.
|
|
odtLongVarBinary
|
A long binary value (OleDbParameter only). This maps to an Array of type Byte.
|
