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).
HOME
Printer friendly page
