OleDbType Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Specifies the data type of a field, a property, for use in an OleDbParameter.
public enum class OleDbTypepublic enum OleDbTypetype OleDbType = Public Enum OleDbType- Inheritance
Fields
| Name | Value | Description |
|---|---|---|
| Empty | 0 | No value (DBTYPE_EMPTY). |
| SmallInt | 2 | A 16-bit signed integer (DBTYPE_I2). This maps to Int16. |
| Integer | 3 | A 32-bit signed integer (DBTYPE_I4). This maps to Int32. |
| Single | 4 | A floating-point number within the range of -3.40E +38 through 3.40E +38 (DBTYPE_R4). This maps to Single. |
| Double | 5 | A floating-point number within the range of -1.79E +308 through 1.79E +308 (DBTYPE_R8). This maps to Double. |
| Currency | 6 | 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. |
| Date | 7 | 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. |
| BSTR | 8 | A null-terminated character string of Unicode characters (DBTYPE_BSTR). This maps to String. |
| IDispatch | 9 | A pointer to an This data type is not currently supported by ADO.NET. Its usage may cause unpredictable results. |
| Error | 10 | A 32-bit error code (DBTYPE_ERROR). This maps to Exception. |
| Boolean | 11 | A Boolean value (DBTYPE_BOOL). This maps to Boolean. |
| Variant | 12 | 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. This maps to Object. |
| IUnknown | 13 | A pointer to an |
| Decimal | 14 | A fixed precision and scale numeric value between -10 38 -1 and 10 38 -1 (DBTYPE_DECIMAL). This maps to Decimal. |
| TinyInt | 16 | A 8-bit signed integer (DBTYPE_I1). This maps to SByte. |
| UnsignedTinyInt | 17 | A 8-bit unsigned integer (DBTYPE_UI1). This maps to Byte. |
| UnsignedSmallInt | 18 | A 16-bit unsigned integer (DBTYPE_UI2). This maps to UInt16. |
| UnsignedInt | 19 | A 32-bit unsigned integer (DBTYPE_UI4). This maps to UInt32. |
| BigInt | 20 | A 64-bit signed integer (DBTYPE_I8). This maps to Int64. |
| UnsignedBigInt | 21 | A 64-bit unsigned integer (DBTYPE_UI8). This maps to UInt64. |
| Filetime | 64 | A 64-bit unsigned integer representing the number of 100-nanosecond intervals since January 1, 1601 (DBTYPE_FILETIME). This maps to DateTime. |
| Guid | 72 | A globally unique identifier (or GUID) (DBTYPE_GUID). This maps to Guid. |
| Binary | 128 | A stream of binary data (DBTYPE_BYTES). This maps to an Array of type Byte. |
| Char | 129 | A character string (DBTYPE_STR). This maps to String. |
| WChar | 130 | A null-terminated stream of Unicode characters (DBTYPE_WSTR). This maps to String. |
| Numeric | 131 | An exact numeric value with a fixed precision and scale (DBTYPE_NUMERIC). This maps to Decimal. |
| DBDate | 133 | Date data in the format yyyymmdd (DBTYPE_DBDATE). This maps to DateTime. |
| DBTime | 134 | Time data in the format hhmmss (DBTYPE_DBTIME). This maps to TimeSpan. |
| DBTimeStamp | 135 | Data and time data in the format yyyymmddhhmmss (DBTYPE_DBTIMESTAMP). This maps to DateTime. |
| PropVariant | 138 | An automation PROPVARIANT (DBTYPE_PROP_VARIANT). This maps to Object. |
| VarNumeric | 139 | A variable-length numeric value (OleDbParameter only). This maps to Decimal. |
| VarChar | 200 | A variable-length stream of non-Unicode characters (OleDbParameter only). This maps to String. |
| LongVarChar | 201 | A long string value (OleDbParameter only). This maps to String. |
| VarWChar | 202 | A variable-length, null-terminated stream of Unicode characters (OleDbParameter only). This maps to String. |
| LongVarWChar | 203 | A long null-terminated Unicode string value (OleDbParameter only). This maps to String. |
| VarBinary | 204 | A variable-length stream of binary data (OleDbParameter only). This maps to an Array of type Byte. |
| LongVarBinary | 205 | A long binary value (OleDbParameter only). This maps to an Array of type Byte. |
Remarks
The preceding table shows mappings between OleDbType data types, OLE DB data types (shown in parentheses), and the .NET Framework types. The OleDbType data types accept System.Char[] as Parameter.Value in parameterized queries.
