|
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 |
|
