2024年4月22日发(作者：)

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

The table below shows the ADO Data Type mapping between Access, SQL Server, and Oracle:

DataType Enum

adBigInt

adBinary

adBoolean

adChar

adCurrency

adDate

adDBTimeStamp

adDecimal

adDouble

adGUID

Value

20

128

11

129

6

7

135

14

5

72

Access

YesNo

Currency

Date

SQLServer

BigInt (SQL Server

2000 +)

Binary

TimeStamp

Bit

Char

Money

SmallMoney

DateTime

Oracle

Raw *

Char

Date

Decimal *

Float

DateTime (Access 97 DateTime

(ODBC)) SmallDateTime

Double

Float

ReplicationID UniqueIdentifier

(Access 97 (OLEDB)), (SQL Server 7.0 +)

(Access 2000

(OLEDB))

AutoNumber

Integer

Long

OLEObject

Memo (Access 97)

Hyperlink (Access

97)

adIDispatch

adInteger

9

3

Identity (SQL Server Int *

6.5)

Int

Image

Text

Long Raw *

Blob (Oracle 8.1.x)

Long *

Clob (Oracle 8.1.x)

NClob (Oracle 8.1.x)

adLongVarBinary

adLongVarChar

205

201

adLongVarWChar 203 Memo (Access 2000 NText (SQL Server

(OLEDB)) 7.0 +)

Hyperlink (Access

2000 (OLEDB))

Decimal (Access

2000 (OLEDB))

Decimal

Numeric

adNumeric 131 Decimal

Integer

Number

SmallInt

adSingle

adSmallInt

4

2

Single

Integer

Byte

ReplicationID

(Access 97)

Text (Access 97)

Text (Access 2000

(OLEDB))

Real

SmallInt

TinyInt

VarBinary

VarChar

Sql_Variant (SQL

Server 2000 +)

NVarChar (SQL

Server 7.0 +)

NChar (SQL Server

7.0 +)

VarChar

VarChar2

NVarChar2

adUnsignedTinyInt 17

adVarBinary

adVarChar

adVariant

adVarWChar

adWChar

204

200

12

202

130

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

Access中的数据类型如下

文本 nvarchar(n)

备注 ntext

数字(长整型) int

数字(整型) smallint

数字(单精度) real

数字(双精度) float

数字(字节) tinyint

货币 money

日期 smalldatetime

布尔 bit