Access, SQL Server, and Oracle数据类型的对应关系

 

The table below shows the ADO Data Type mapping between Access, SQL Server, and 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 +)

 

* In Oracle 8.0.x - decimal and int are equal to number and number(10).