ASP里使用存储过程时需要用到的ADO 数据类型对照表收藏


  • :
  • 01-23 21:21
  • :
  • 5次
  • :
  • 0条
  • 1赞

简介完整的ADO 数据类型对照参考表

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

DataType EnumValueAccessSQLServerOracle
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 +) 


您正在找的文章可能是: