Access与Sql Server 及Oracle数据类型对比表（区别，异同）

DataType Enum

Value

Access

SQLServer

Oracle

adBigInt

20

BigInt (SQL Server 2000 +)

adBinary

128

Binary
TimeStamp

Raw *

adBoolean

11

YesNo

Bit

adChar

129

Char

Char

adCurrency

6

Currency

Money
SmallMoney

adDate

7

Date

DateTime

adDBTimeStamp

135

DateTime (Access 97 (ODBC))

DateTime
SmallDateTime

Date

adDecimal

14

Decimal *

adDouble

5

Double

Float

Float

adGUID

72

ReplicationID (Access 97 (OLEDB)), (Access 2000 (OLEDB))

UniqueIdentifier (SQL Server 7.0 +)

adIDispatch

9

adInteger

3

AutoNumber
Integer
Long

Identity (SQL Server 6.5)
Int
 

Int *

adLongVarBinary

205

OLEObject

Image

Long Raw *
Blob (Oracle 8.1.x)

adLongVarChar

201

Memo (Access 97)
Hyperlink (Access 97)

Text

Long *
Clob (Oracle 8.1.x)

adLongVarWChar

203

Memo (Access 2000 (OLEDB))
Hyperlink (Access 2000 (OLEDB))

NText (SQL Server 7.0 +)

NClob (Oracle 8.1.x)

adNumeric

131

Decimal (Access 2000 (OLEDB))

Decimal
Numeric

Decimal
Integer
Number
SmallInt

adSingle

4

Single

Real

adSmallInt

2

Integer

SmallInt

adUnsignedTinyInt

17

Byte

TinyInt

adVarBinary

204

ReplicationID (Access 97)

VarBinary

adVarChar

200

Text (Access 97)

VarChar

VarChar

adVariant

12

Sql_Variant (SQL Server 2000 +)

VarChar2

adVarWChar

202

Text (Access 2000 (OLEDB))

NVarChar (SQL Server 7.0 +)

NVarChar2

adWChar

130

NChar (SQL Server 7.0 +)