The following table lists the data type mappings 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 | |
AdDBTimeSta mp | 135 | DateTime (Access 97 (ODBC)) | DateTime SmallDateTi me | Date |
AdDecimal | 14 | Decimal* | ||
AdDouble | 5 | Double | Float | Float |
AdGUID | 72 | Replication ID (Access 97 (OLEDB)), (Access 2000 (OLEDB)) | UniqueIdent ifier (SQL Server 7.0 +) | |
AdIDispatch | 9 | |||
AdInteger | 3 | AutoNumber Integer Long | Identity (SQL Server 6.5) Int | Int* |
AdLongVarBi nary | 205 | OLEObject | Image | Long Raw* Blob (Oracle 8.1.x) |
AdLongVarCh ar | 201 | Memo (Access 97) Hyperlink (Access 97) | Text | Long* Clob (Oracle 8.1.x) |
AdLongVarWC har | 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 | |
AdUnsignedT inyInt | 17 | Byte | TinyInt | |
AdVarBinary | 204 | Replication ID (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 equal to number and number(10) .