- skip to content

# Database Abstraction Layer

### User Tools

- Login

### Site Tools

- Recent changes
- Media Manager
- Sitemap

### Sidebar

##### Resources

- Reference Manual
- User Guide
- The Data Dictionary
- ADOdb-xmlschema
- ADOdb Active Record
- Performance Monitoring
- Date/Time Library
- Session Management Library
- Unsupported Addons
- Coding Standards

##### Supported Databases

- Access
- ADO
- CSV
- Firebird
- Frontbase
- IBM DB2
- Informix
- Interbase
- LDAP
- Microsoft SQL Server
- MySQL
- Netezza
- ODBC
- ODBTP
- Oracle
- PDO
- Postgresql
- SAP ADS
- SAP ASE
- SAP Maxdb
- SAP Sqlanywhere
- Sqlite
- Sybase
- Plain Text
- Visual Foxpro

##### Other

- Feature Comparison Matrix
- Connection Matrix
- Include File Guide

v5:database:feature_comparison

# Feature Comparison Matrix

ADOdb features, by Database Type

Check that the 'Verified' column is checked before relying on information

| Access | ADO | CSV | Firebird | Frontbase Interbase | IBM DB2 | Informix | Microsoft SQL Server | MySQL | Netezza | ODBC | ODBTP | Oracle | PostgreSQL | SAP ADS | SAP DB | SQLite | Sybase | Text | Visual FoxPro
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
Verified | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No
Sequences |  |  | No |  | Yes | Yes |  | Yes1) | Emulated |  | Emulated |  | Yes | Yes |  |  |  |  | No |
ADODB_FETCH_BOTH | No |  | No |  |  | Yes |  | Yes | Yes |  |  |  |  |  |  |  |  |  | No |
Transactions | No | Yes | No | Yes | Yes | Yes | Yes | Yes | Yes2) | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | Yes
Record Counting | Emulated |  | No |  |  |  |  |  |  |  |  |  |  |  |  |  | Emulated |  | No |
selectLimit() |  |  | No |  |  | Emulated3) |  | Yes | Yes |  |  |  | Yes |  |  |  |  |  | No |
Date Offset Functions | No |  | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |
MetaTables Masking | No | No | No | No | No | No | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | Yes
rowLock row locking | No |  | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |
rowLock column locking | No |  | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |
setCharSet4) | No | No | No | No | No | No | No | No | Yes | No | No | No | No | Yes | No | No | No | No | No | No
Blob Handling | No | No | No | No | No | Yes | No | Yes | No | No | No | No | No | No | No | No | No | No | No | No
Stored Procedures | No | No | No | No | No | No | No | Yes | No | No | No | No | Yes | No | No | No | No | No | No | No
Performance Monitoring | No | No | No | No | No | Yes | Yes | Yes | Yes | No | No | No | Yes | Yes | No | No | No | No | No | No

1) Emulated in Server 2008 and lower
2) Transactional Tables Only
3) Native if query constructed so that TOP n records can be used
4) Superceeded by setConnectionParameter()
v5/database/feature_comparison.txt · Last modified: 2016/01/13 08:20 by mnewnham

### Page Tools

- Show pagesource
- Old revisions
- Backlinks
- Rename Page
- Back to top