OleDbType Enum

Definition

Namespace:

System.Data.OleDb

Assembly:

System.Data.OleDb.dll

Package:

System.Data.OleDb v9.0.0-rc.2.24473.5

Specifies the data type of a field, a property, for use in an OleDbParameter.

public enum class OleDbType

public enum OleDbType

type OleDbType = 

Public Enum OleDbType

Inheritance

Object

ValueType

Enum

OleDbType

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 IDispatch interface (DBTYPE_IDISPATCH). This maps to Object. 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 IUnknown interface (DBTYPE_UNKNOWN). This maps to Object. This data type is not currently supported by ADO.NET. Its usage may cause unpredictable results.
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.