ADO 数据类型转换表--打印文章

adBigInt20Int64
SqlDbType.BigInt¹⁰OleDbType.BigInt ¹¹bigint ⁹8 VariantadBinary128Byte[]
SqlDbType.VarBinary¹⁰OleDbType.Binary ¹¹binary
timestamp50
8 Raw ⁷ VariantadBoolean11Boolean
SqlDbType.Bit¹⁰
OleDbType.Boolean ¹¹bit
1
2

YesNo BooleanadBSTR8String
OleDbType.BSTR ¹¹ adChapter136(DataReader) adChar129String
SqlDbType.Char¹⁰OleDbType.Char ¹¹charX CharStringadCurrency6Decimal
SqlDbType.Money ¹⁰OleDbType.Currency ¹¹money
smallmoney
8
4
0

Currency CurrencyadDate7DateTime
OleDbType.DBDate ¹¹
0
DateTime ² DateadDBDate133DateTime
OleDbType.DBDate ¹¹ adDBFileTime137DBFileTime ¹¹ adDBTime134DateTime
OleDbType.DBTime ¹¹ adDBTimeStamp135DateTime
SqlDbType.DateTime¹⁰OleDbType.DBTimeStamp ¹¹datetime
smalldatetime
8
4
0

DateTime ¹DateDateadDecimal14Decimal
OleDbType.Decimal ¹¹ Decimal ⁷ Variant ⁶adDouble5Double
SqlDbType.Float¹⁰OleDbType.Double ¹¹float
8
0

DoubleFloatDoubleadEmpty0Empty ¹¹ adError10External-Exception
OleDbType.Error ¹¹ adFileTime64DateTime
OleDbType.Filetime ¹¹ adGUID72Guid
SqlDbType.UniqueIdentifier¹⁰OleDbType.Guid ¹¹uniqueidentifier⁵16

ReplicationID^2,3 VariantadIDispatch9Object
OleDbType.IDispatch ¹¹ adInteger3Int32
SqlDbType.Int¹⁰OleDbType.Integer ¹¹

identity ⁴
int

4
4

AutoNumber
Long IntegerInt ⁷ LongadIUnknown13Object
OleDbType.IUnknown ¹¹ adLongVarBinary205Byte[]
SqlDbType.VarBinary¹⁰OleDbType.LongVarBinary ¹¹image2147483647

OLEObjectLong Raw ⁷Blob ⁸VariantadLongVarChar201String
SqlDbType.VarChar¹⁰OleDbType.LongVarChar ¹¹text2147483647
Memo ^{1, 2}
Hyperlink ^{1, 2}Long ⁷Clob ⁸StringadLongVarWChar203String
SqlDbType.NText¹⁰OleDbType.VarWChar ¹¹ntext ⁵1073741823
Memo ³
Hyperlink ³NClob ⁸StringadNumeric131Decimal
SqlDbType.Decimal¹⁰OleDbType.Decimal ¹¹decimal
numeric
9


Decimal ³Decimal
Integer
Number
SmallIntVariant ⁶adPropVariant138Object
OleDbType.PropVariant ¹¹ adSingle4Single
SqlDbType.Real¹⁰OleDbType.Single ^{[1] [2]  下一页}