BigInt
| BigInt
| Int64—
A 64-bit signed integer.
|
Binary
| Binary
| Array of type Byte—
A fixed-length stream of binary data ranging between 1 and 8,000 bytes.
|
Bit
| -
| Boolean—
An unsigned numeric value that can be 0, 1, or a null reference (Nothing in Visual Basic).
|
-
| Boolean
| Boolean—
A boolean value (DBTYPE_BOOL).
|
-
| BSTR
| String—
A null-terminated character string of Unicode characters (DBTYPE_BSTR).
|
Char
| Char
| String—
A fixed-length stream of non-Unicode characters ranging between 1 and 8,000 characters.
|
DateTime
| Date
| DateTime—
Date and time data ranging in value from January 1, 1753 to December 31, 9999 to an accuracy of 3.33 milliseconds.
|
-
| DBDate
| DateTime—
Date data in the format yyyymmdd (DBTYPE_DBDATE).
|
| DBTime
| TimeSpan—
Time data in the format hhmmss (DBTYPE_DBTIME).
|
Decimal
| Decimal
| Decimal—
A fixed precision and scale numeric value between –10E38 –1 and 10E38 –1.
|
-
| Empty
| Empty—
No value (DBTYPE_EMPTY).
|
-
| Error
| Exception—
A 32-bit error code (DBTYPE_ERROR).
|
-
| Filetime
| DateTime—
A 64-bit unsigned integer representing the number of 100- nanosecond intervals since January 1, 1601 (DBTYPE_FILETIME).
|
Float
| Double
| Double—
A floating point number within the range of –1.79E +308 through 1.79E +308.
|
Image
| -
| Array of type Byte—
A variable-length stream of binary data ranging from 0 to 2E31 –1(or 2,147,483,647) bytes.
|
Int
| Integer
| Int32—
A 32-bit signed integer.
|
-
| LongVarBinary
| Array of type Byte—
A long binary value (OleDbParameter only).
|
-
| LongVarWChar
| String—
A long string value (OleDbParameter only).
|
-
| Numeric
| Decimal—
An exact numeric value with a fixed precision and scale (DBTYPE_NUMERIC).
|
Money
| Currency
| Decimal—
Currency value ranging from –2E63 (or –922,337,203,685,477.5808) to 2E63 –1(or +922,337,203,685,477.5807) with an accuracy to a ten-thousandth of a currency unit.
|
NChar
| -
| String—
A fixed-length stream of Unicode characters ranging between 1 and 4,000 characters.
|
NText
| -
| String—
A variable-length stream of Unicode data with a maximum length of 2E30 –1 (or 1,073,741,823) characters.
|
NVarChar
| -
| String—
A variable-length stream of Unicode characters ranging between 1 and 4,000 characters. Note: Implicit conversion fails if the string is greater than 4,000 characters. Explicitly set the object when working with strings longer than 4,000 characters.
|
-
| PropVariant
| Object—
An automation PROPVARIANT (DBTYPE_PROP_VARIANT).
|
Real
| Single
| Single—
A floating point number within the range of –3.40E +38 through 3.40E +38.
|
SmallDateTime
| -
| DateTime—
Date and time data ranging in value from January 1, 1900 to June 6, 2079 to an accuracy of one minute.
|
SmallInt
| SmallInt
| Int16—
A 16-bit signed integer.
|
SmallMoney
| -
| Decimal—
A currency value ranging from –214,748.3648 to +214,748.3647 with an accuracy to a ten-thousandth of a currency unit.
|
Text
| LongVarChar
| String—
A variable-length stream of non-Unicode data with a maximum length of 2E31 –1(or 2,147,483,647) characters.
|
Timestamp
| DBTimestamp
| DateTime—
Date and time data in the format yyyymmddhhmmss.
|
TinyInt
| TinyInt
| Byte—
An 8-bit unsigned integer.
|
UniqueIdentifier
| Guid
| Guid—
A globally unique identifier (or GUID).
|
-
| UnsignedBigInt
| UInt64—
A 64-bit unsigned integer (DBTYPE_UI8).
|
-
| UnsignedInt
| UInt32—
A 32-bit unsigned integer (DBTYPE_UI4).
|
-
| UnsignedSmallInt
| UInt16—
A 16-bit unsigned integer (DBTYPE_UI2).
|
-
| UnsignedTinyInt
| UInt8—
An 8-bit unsigned integer (DBTYPE_UI1).
|
VarBinary
| VarBinary
| Array of type Byte—
A variable-length stream of binary data ranging between 1 and 8,000 bytes. Note: Implicit conversion fails if the byte array is greater than 8,000 bytes. Explicitly set the object when working with byte arrays larger than 8,000 bytes.
|
VarChar
| VarChar
| String—
A variable-length stream of non-Unicode characters ranging between 1 and 8,000 characters.
|
Variant
| Variant
| Object—
A special data type that can contain numeric, string, binary, or date data as well as the SQL Server values Empty and Null, which is assumed if no other type is declared.
|
-
| VarNumeric
| Decimal—
A variable-length numeric value (OleDbParameter only).
|
-
| VarWChar
| String—
A variable-length, null- terminated stream of Unicode characters (OleDbParameter only).
|
-
| WChar
| String—
A null-terminated stream of Unicode characters (DBTYPE_WSTR).
|