导航

ADO 数据类型转换表 oledbtype sqldbtype (二)

Posted on 2008-04-09 18:51  菜鸟都不容易  阅读(183)  评论(0编辑  收藏  举报
 
adIDispatch 9 Object
OleDbType.IDispatch
11
         
adInteger 3 Int32
SqlDbType.Int 10
OleDbType.Integer
11

identity 4
int
 

4
4
 
 
AutoNumber
Long Integer
Int 7 Long
adIUnknown 13 Object
OleDbType.IUnknown
11
         
adLongVarBinary 205 Byte[]
SqlDbType.VarBinary 10
OleDbType.LongVarBinary
11
image 2147483647  
 
OLEObject
Long Raw 7
Blob
8
Variant
adLongVarChar 201 String
SqlDbType.VarChar 10
OleDbType.LongVarChar
11
text 2147483647  
Memo 1, 2
Hyperlink
1, 2
Long 7
Clob
8
String
adLongVarWChar 203 String
SqlDbType.NText 10
OleDbType.VarWChar
11
ntext 5 1073741823  
Memo 3
Hyperlink
3
NClob 8 String
adNumeric 131 Decimal
SqlDbType.Decimal 10
OleDbType.Decimal
11
decimal
numeric
 
9
 
 
 
Decimal
3
Decimal
Integer
Number
SmallInt
Variant 6
adPropVariant 138 Object
OleDbType.PropVariant
11
         
adSingle 4 Single
SqlDbType.Real 10
OleDbType.Single
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