ADO
DataType
Enum |
ADO
DataType
Enum
Value |
.NET
Framework |
Visual
Basic
6.0 |
Access |
SQL
Server |
Oracle |
adBigInt |
20 |
Int64
SqlInt64
BigInt |
Variant |
|
BigInt |
|
adBinary |
128 |
Byte[]
SqlBinary
Binary |
Variant |
|
Binary
TimeStamp |
Raw |
adBoolean |
11 |
Boolean
SqlBoolean
Boolean |
Boolean |
YesNo |
Bit |
|
adBSTR |
8 |
String
BSTR |
|
|
|
|
adChapter |
136 |
(DataReader) |
|
|
|
|
adChar |
129 |
String
SqlString
Char |
String |
|
Char |
Char |
adCurrency |
6 |
Decimal
SqlMoney
Currency |
Currency |
Currency |
Money
SmallMoney |
|
adDate |
7 |
DateTime
Date |
Date |
DateTime |
|
|
adDBDate |
133 |
DateTime
DBDate |
|
|
|
|
adDBFileTime |
137 |
DBFileTime |
|
|
|
|
adDBTime |
134 |
DateTime
DBTime |
|
|
|
|
adDBTimeStamp |
135 |
DateTime
SqlDateTime
DBTimeStamp |
Date |
DateTime |
Datetime
SmallDateTime |
Date |
adDecimal |
14 |
Decimal
Decimal |
Variant |
|
|
Decimal |
adDouble |
5 |
Double
SqlDouble
Double |
Double |
Double |
Float |
Float |
adEmpty |
0 |
Empty |
|
|
|
|
adError |
10 |
External-Exception
Error |
|
|
|
|
adFileTime |
64 |
DateTime
Filetime |
|
|
|
|
adGUID |
72 |
Guid
SqlGuid
Guid |
Variant |
ReplicationID |
UniqueIdentifier |
|
adIDispatch |
9 |
Object
IDispatch |
|
|
|
|
adInteger |
3 |
Int32
SqlInt32
Integer |
Long |
AutoNumber
Integer
Long |
Identity
Int |
Int |
adIUnknown |
13 |
Object
IUnknown |
|
|
|
|
adLongVarBinary |
205 |
Byte[]
SqlBinary
LongVarBinary |
Variant |
OLEObject |
Image |
Long Raw
Blob |
adLongVarChar |
201 |
String
SqlString
LongVarChar |
String |
Memo
Hyperlink |
Text |
Long
Clob |
adLongVarWChar |
203 |
String
SqlString
LongVarWChar |
String |
Memo
Hyperlink |
NText |
NClob |
adNumeric |
131 |
Decimal
SqlDecimal
Numeric |
Variant |
Decimal |
Decimal
Numeric |
Decimal
Integer
Number
SmallInt |
adPropVariant |
138 |
Object
PropVariant |
|
|
|
|
adSingle |
4 |
Single
SqlSingle
SIngle |
Single |
Single |
Real |
|
adSmallInt |
2 |
Int16,
SqlInt16
SmallInt |
Integer |
Integer |
SmallInt |
|
adTinyInt |
16 |
Byte
TinyInt |
|
|
|
|
adUnsignedBigInt |
21 |
UInt64
UnsignedBigInt |
|
|
|
|
adUnsignedInt |
19 |
UInt32
UnsignedInt |
|
|
|
|
adUnsignedSmallInt |
18 |
UInt16
UnsignedSmallInt |
|
|
|
|
adUnsignedTinyInt |
17 |
Byte
SqlByte
UnsignedTinyInt |
Byte |
Byte |
TinyInt |
|
adUserDefined |
132 |
|
|
|
|
|
adVarBinary |
204 |
Byte[]
SqlBinary
VarBinary |
Variant |
ReplicationID |
VarBinary |
|
adVarChar |
200 |
String
SqlString
VarChar |
String |
Text |
VarChar |
VarChar |
adVariant |
12 |
Object
Variant |
Variant |
|
Sql_Variant |
VarChar2 |
adVarNumeric |
139 |
VarNumeric |
|
|
|
|
adVarWChar |
202 |
String
SqlString
VarWChar |
String |
Text |
NVarChar |
NVarChar2 |
adWChar |
130 |
String
SqlString
WChar |
String |
|
NChar |
|