ADO 数据类型


下面的表格列出了 Access、SQL Server 与 Oracle 之间的数据类型映射:

DataType EnumAccessSQLServerOracle
adBigInt20 BigInt (SQL Server 2000 +) 
adBinary128 Binary
TimeStamp
Raw *
adBoolean11YesNoBit 
adChar129 CharChar
adCurrency6CurrencyMoney
SmallMoney
 
adDate7DateDateTime 
adDBTimeStamp135DateTime (Access 97 (ODBC))DateTime
SmallDateTime
Date
adDecimal14  Decimal *
adDouble5DoubleFloatFloat
adGUID72ReplicationID (Access 97 (OLEDB)), (Access 2000 (OLEDB))UniqueIdentifier (SQL Server 7.0 +) 
adIDispatch9   
adInteger3AutoNumber
Integer
Long
Identity (SQL Server 6.5)
Int
 
Int *
adLongVarBinary205OLEObjectImageLong Raw *
Blob (Oracle 8.1.x)
adLongVarChar201Memo (Access 97)
Hyperlink (Access 97)
TextLong *
Clob (Oracle 8.1.x)
adLongVarWChar203Memo (Access 2000 (OLEDB))
Hyperlink (Access 2000 (OLEDB))
NText (SQL Server 7.0 +)NClob (Oracle 8.1.x)
adNumeric131Decimal (Access 2000 (OLEDB))Decimal
Numeric
Decimal
Integer
Number
SmallInt
adSingle4SingleReal 
adSmallInt2IntegerSmallInt 
adUnsignedTinyInt17ByteTinyInt 
adVarBinary204ReplicationID (Access 97)VarBinary 
adVarChar200Text (Access 97)VarCharVarChar
adVariant12 Sql_Variant (SQL Server 2000 +)VarChar2
adVarWChar202Text (Access 2000 (OLEDB))NVarChar (SQL Server 7.0 +)NVarChar2
adWChar130 NChar (SQL Server 7.0 +) 

* 在 Oracle 8.0.x 中 - decimal 和 int 等于 number 和 number(10)。

关注极客云图了解更多内容