11
real
4
Single
Single
adSmallInt
2
Int16,
SqlDbType.SmallInt 10
OleDbType.SmallInt 11
smallInt
2
Integer
Integer
adTinyInt
16
Byte
OleDbType.TinyInt 11
adUnsignedBigInt
21
UInt64
OleDbType.UnsignedBigInt 11
adUnsignedInt
19
UInt32
OleDbType.UnsignedInt 11
adUnsignedSmallInt
18
UInt16
OleDbType.UnsignedSmallInt 11
adUnsignedTinyInt
17
Byte
SqlDbType.TinyInt 10
OleDbType.UnsignedTinyInt 11
tinyInt
1
Byte
Byte
adUserDefined
132
adVarBinary
204
Byte[]
SqlDbType.VarBinary 10
OleDbType.VarBinary 11
varbinary
50
ReplicationID 1
Variant
adVarChar
200
String
SqlDbType.VarChar 10
OleDbType.VarChar 11
varchar
X
Text 1, 2
VarChar
String
adVariant
12
Object
SqlDbType.Variant 10
OleDbType.Variant 11
sql_variant 9
8016
VarChar2
Variant
adVarNumeric
139
OleDbType.VarNumeric 11
adVarWChar
202
String
SqlDbType.NVarChar 10
OleDbType.VarWChar 11
nvarchar 5
X
Text 3
NVarChar2
String
adWChar
130
String
SqlDbType.NChar 10
OleDbType.WChar 11
nchar 5
X
String
Top of Page
1 - ODBC Driver (3.51.171300): Microsoft Access Driver (*.mdb), Access 97 (3.5 format)
2 - OLE DB Provider: Microsoft.Jet.OLEDB.3.51, Access 97 (3.5 format)
3 - OLE DB Provider: Microsoft.Jet.OLEDB.4.0 , Access 2000 (4.0 format)
4 - OLE DB Provider: SQLOLEDB, SQL Server 6.5
5 - OLE DB Provider: SQLOLEDB, SQL Server 7.0 +
6 - The VB Decimal data type can only be used within a Variant, that is, you cannot declare
a VB variable to be of type Decimal.
7 - Oracle 8.0.x Note: DECIMAL and INT are synonyms for NUMBER and NUMBER(10) respectively.
8 - Oracle 8.1.x
9 - OLE DB Provider: SQLOLEDB, SQL Server 2000 +
10 - SQL Server .NET Data Provider (via System.Data.SqlTypes)
11 - OLE DB .NET Data Provider (via System.Data.OleDb)
上一页 [1] [2] |
