ole db 数据类型映射

《ole db 数据类型映射》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、OLEDB数据类型映射OLEDB数据类型映射(ADO.NET)下表显示了针对适用于ADO和OLEDB的.NETFramework数据提供程序(System.Data.OleDb)中的数据类型推断出的.NETFramework类型。另外，还列出了OleDbDataReader的类型化访问器方法。ADO类型OLEDB类型.NETFramework类型.NETFramework类型化访问器adBigIntDBTYPE_I8Int64GetInt64()adBinaryDBTYPE_BYTESByte[]GetBytes()adBooleanDBTYPE_BOOLBoolea

2、nGetBoolean()adBSTRDBTYPE_BSTRStringGetString()adChapterDBTYPE_HCHAPTER通过DataReader支持。请参见使用DataReader检索数据(ADO.NET)。GetValue()adCharDBTYPE_STRStringGetString()adCurrencyDBTYPE_CYDecimalGetDecimal()adDateDBTYPE_DATEDateTimeGetDateTime()adDBDateDBTYPE_DBDATEDateTimeGetDateTime()adDBTimeDBT

3、YPE_DBTIMEDateTimeGetDateTime()adDBTimeStampDBTYPE_DBTIMESTAMPDateTimeGetDateTime()adDecimalDBTYPE_DECIMALDecimalGetDecimal()adDoubleDBTYPE_R8DoubleGetDouble()adErrorDBTYPE_ERRORExternalExceptionGetValue()adFileTimeDBTYPE_FILETIMEDateTimeGetDateTime()adGUIDDBTYPE_GUIDGuidGetGuid()adIDis

4、patchDBTYPE_IDISPATCH*ObjectGetValue()adIntegerDBTYPE_I4Int32GetInt32()adIUnknownDBTYPE_IUNKNOWN*ObjectGetValue()adNumericDBTYPE_NUMERICDecimalGetDecimal()adPropVariantDBTYPE_PROPVARIANTObjectGetValue()adSingleDBTYPE_R4SingleGetFloat()adSmallIntDBTYPE_I2Int16GetInt16()adTinyIntDBTYPE_I1

5、ByteGetByte()adUnsignedBigIntDBTYPE_UI8UInt64GetValue()adUnsignedIntDBTYPE_UI4UInt32GetValue()adUnsignedSmallIntDBTYPE_UI2UInt16GetValue()adUnsignedTinyIntDBTYPE_UI1ByteGetByte()adVariantDBTYPE_VARIANTObjectGetValue()adWCharDBTYPE_WSTRStringGetString()adUserDefinedDBTYPE_UDT不受支持   adVar

6、NumericDBTYPE_VARNUMERIC不受支持   *对于OLEDB类型DBTYPE_IUNKNOWN和DBTYPE_IDISPATCH，对象引用是指针的封送表示形式。OLEDB数据类型OLEDB程序员参考的附录ADO数据类型2010-03-1418:13ADO数据类型下面的表格列出了Access、SQLServer与Oracle之间的数据类型映射：DataTypeEnumValueAccessSQLServerOracleadBigInt20BigInt(SQLServer2000+)adBinary128BinaryTimeStampRaw*adBool

7、ean11YesNoBitadChar129CharCharadCurrency6CurrencyMoneySmallMoneyadDate7DateDateTimeadDBTimeStamp135DateTime(Access97(ODBC))DateTimeSmallDateTimeDateadDecimal14Decimal*adDouble5DoubleFloatFloatadGUID72ReplicationID(Access97(OLEDB)),(Access2000(OLEDB))UniqueIdentifier(SQLServer7.