ADODataTypes与值对应

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

ThetablebelowshowstheADODataTypemappingbetween,,and:

DataTypeEnumValueAccessSQLServerOracleadBigInt20 BigInt(SQLServer2000+) adBinary128 Binary
TimeStampRaw*adBoolean11YesNoBit adChar129 CharCharadCurrency6CurrencyMoney
SmallMoney adDate7DateDateTime adDBTimeStamp135DateTime(Access97(ODBC))DateTime
SmallDateTimeDateadDecimal14  Decimal*adDouble5DoubleFloatFloatadGUID72ReplicationID(Access97(OLEDB)),(Access2000(OLEDB))UniqueIdentifier(SQLServer7.0+) adIDispatch9   adInteger3AutoNumber
Integer
LongIdentity(SQLServer6.5)
Int
 Int*adLongVarBinary205OLEObjectImageLongRaw*
Blob(Oracle8.1.x)adLongVarChar201Memo(Access97)
Hyperlink(Access97)TextLong*
Clob(Oracle8.1.x)adLongVarWChar203Memo(Access2000(OLEDB))
Hyperlink(Access2000(OLEDB))NText(SQLServer7.0+)NClob(Oracle8.1.x)adNumeric131Decimal(Access2000(OLEDB))Decimal
NumericDecimal
Integer
Number
SmallIntadSingle4SingleReal adSmallInt2IntegerSmallInt adUnsignedTinyInt17ByteTinyInt adVarBinary204ReplicationID(Access97)VarBinary adVarChar200Text(Access97)VarCharVarCharadVariant12 Sql_Variant(SQLServer2000+)VarChar2adVarWChar202Text(Access2000(OLEDB))NVarChar(SQLServer7.0+)NVarChar2adWChar130 NChar(SQLServer7.0+) 

*InOracle8.0.x-decimalandintareequaltonumberandnumber(10).
<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>