ADO对应SQLServer数据类型转换表.docVIP

随笔- 39 文章- 0 评论- 10 ADO 数据类型转换表 ADODataTypeEnum ADODataTypeEnumValue .NETFramework SQLServer! Size Access文件 Oracle VisualBasic6.0 adBigInt 20 Int64SqlDbType.BigInt 10OleDbType.BigInt 11 bigint 9 8 Variant adBinary 128 Byte[]SqlDbType.VarBinary 10OleDbType.Binary 11 binarytimestamp 508 Raw 7 Variant adBoolean 11 BooleanSqlDbType.Bit 10OleDbType.Boolean 11 bit 12  YesNo Boolean adBSTR 8 StringOleDbType.BSTR 11 adChapter 136 (DataReader) adChar 129 String SqlDbType.Char 10OleDbType.Char 11 char X Char String adCurrency 6 DecimalSqlDbType.Money 10OleDbType.Currency 11 moneysmallmoney 840  Currency Currency adDate 7 DateTimeOleDbType.DBDate 11 0 DateTime 2 Date adDBDate 133 DateTimeOleDbType.DBDate 11 adDBFileTime 137 DBFileTime 11 adDBTime 134 DateTimeOleDbType.DBTime 11 adDBTimeStamp 135 DateTimeSqlDbType.DateTime 10OleDbType.DBTimeStamp 11 datetime smalldatetime 840  DateTime 1 Date Date adDecimal 14 DecimalOleDbType.Decimal 11 Decimal 7 Variant 6 adDouble 5 DoubleSqlDbType.Float 10OleDbType.Double 11 float 80  Double Float Double adEmpty 0 Empty 11 adError 10 External-ExceptionOleDbType.Error 11 adFileTime 64 DateTimeOleDbType.Filetime 11 adGUID 72 Guid SqlDbType.UniqueIdentifier 10OleDbType.Guid 11 uniqueidentifier5 16  ReplicationID2,3 Variant adIDispatch 9 ObjectOleDbType.IDispatch 11 adInteger 3 Int32SqlDbType.Int 10OleDbType.Integer 11 identity 4int 44 AutoNumberLong Integer Int 7 Long adIUnknown 13 ObjectOleDbType.IUnknown 11 adLongVarBinary 205 Byte[]SqlDbType.VarBinary 10OleDbType.LongVarBinary 11 image 2147483647  OLEObject Long Raw 7Blob 8 Variant adLongVarChar 201 StringSqlDbType.VarChar 10OleDbType.LongVarChar 11 text 2147483647 Memo 1, 2Hyperlink 1, 2 Long 7Clob 8 String adLongVarWChar 203 StringSqlDbTy