ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ADO 数据类型转换表-收集

ADO 数据类型转换表-收集

原创 Linux操作系统 作者:kirinri 时间:2008-01-10 19:19:09 0 删除 编辑
ADO 数据类型转换表-收集

 
ADO
DataType
Enum
ADO
DataType
Enum
Value
.NET
Framework
SQL
Server
Size Access Oracle Visual
Basic
6.0
adBigInt 20 Int64
SqlDbType.BigInt 10OleDbType.BigInt
11
bigint 9 8 Variant
adBinary 128 Byte[]
SqlDbType.VarBinary 10OleDbType.Binary
11
binary
timestamp
50
8
Raw 7 Variant
adBoolean 11 Boolean
SqlDbType.Bit 10
OleDbType.Boolean
11
bit
1
2


YesNo
Boolean
adBSTR 8 String
OleDbType.BSTR
11
adChapter 136 (DataReader)
adChar 129 String
SqlDbType.Char 10OleDbType.Char
11
char X Char String
adCurrency 6 Decimal
SqlDbType.Money 10OleDbType.Currency
11
money
smallmoney
8
4
0


Currency
Currency
adDate 7 DateTime
OleDbType.DBDate
11

0

DateTime
2
Date
adDBDate 133 DateTime
OleDbType.DBDate
11
adDBFileTime 137 DBFileTime 11
adDBTime 134 DateTime
OleDbType.DBTime
11
adDBTimeStamp 135 DateTime
SqlDbType.DateTime 10OleDbType.DBTimeStamp
11
datetime
smalldatetime
8
4
0


DateTime
1
Date Date
adDecimal 14 Decimal
OleDbType.Decimal
11
Decimal 7 Variant 6
adDouble 5 Double
SqlDbType.Float 10OleDbType.Double
11
float
8
0


Double
Float Double
adEmpty 0 Empty 11
adError 10 External-Exception
OleDbType.Error
11
adFileTime 64 DateTime
OleDbType.Filetime
11
adGUID 72 Guid
SqlDbType.UniqueIdentifier 10OleDbType.Guid
11
uniqueidentifier5 16

ReplicationID
2,3
Variant
adIDispatch 9 Object
OleDbType.IDispatch
11
adInteger 3 Int32
SqlDbType.Int 10OleDbType.Integer
11

identity 4
int

4
4

AutoNumber
Long Integer
Int 7 Long
adIUnknown 13 Object
OleDbType.IUnknown
11
adLongVarBinary 205 Byte[]
SqlDbType.VarBinary 10OleDbType.LongVarBinary
11
image 2147483647

OLEObject
Long Raw 7Blob 8 Variant
adLongVarChar 201 String
SqlDbType.VarChar 10OleDbType.LongVarChar
11
text 2147483647
Memo 1, 2
Hyperlink
1, 2
Long 7Clob 8 String
adLongVarWChar 203 String
SqlDbType.NText 10OleDbType.VarWChar
11
ntext 5 1073741823
Memo 3
Hyperlink
3
NClob 8 String
adNumeric 131 Decimal
SqlDbType.Decimal 10OleDbType.Decimal
11
decimal
numeric
9


Decimal
3
Decimal
Integer
Number
SmallInt
Variant 6
adPropVariant 138 Object
OleDbType.PropVariant
11
adSingle 4 Single
SqlDbType.Real 10OleDbType.Single
11
real 4

Single
Single
adSmallInt 2 Int16,
SqlDbType.SmallInt 10OleDbType.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 10OleDbType.UnsignedTinyInt
11
tinyInt 1

Byte
Byte
adUserDefined 132
adVarBinary 204 Byte[]
SqlDbType.VarBinary 10OleDbType.VarBinary
11
varbinary 50

ReplicationID
1
Variant
adVarChar 200 String
SqlDbType.VarChar 10OleDbType.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 10OleDbType.VarWChar
11
nvarchar 5 X

Text
3
NVarChar2 String
adWChar 130 String
SqlDbType.NChar 10OleDbType.WChar
11
nchar 5 X String

发表于:2006.12.22 20:32 ::

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12476590/viewspace-134054/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2007-12-21

  • 博文量
    257
  • 访问量
    495404