YouTipADO Data Types
--
- Home
- HTML
- JavaScript
- CSS
- Vue
- React
- Python3
- Java
- C
- C++
- C#
- AI
- Go
- SQL
- Linux
- VS Code
- Bootstrap
- Git
- Local Bookmarks
ADO Tutorial
ADO TutorialADO IntroductionADO Database ConnectionADO ADO RecordsetοΌRecordsetοΌADO DisplayADO QueryADO SortADO Add RecordADO Update RecordADO Delete RecordADO Accelerate Scripts with GetString()ADO Command ObjectADO Connection ObjectADO Error ObjectADO Field ObjectADO Parameter ObjectADO Property ObjectADO Record ObjectADO Recordset ObjectADO Stream ObjectADO Data TypesADO SummaryADO Examples
Deep Dive
Spreadsheet Software
Data Management
Web Applications and Online Tools
AI Tools, Chatbots and Virtual Assistants
Programming
Computer Science
Programming Languages
Development Tools
ADO Data Types
The table below lists the data type mappings among 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 +) |
*