ADOdb features, by Database Type
Check that the 'Verified' column is checked before relying on information
Tier 1 Drivers are fully supported by members of the ADOdb project, and all contain the full feature list. New feature is available for all drivers on release of feature
Tier 2 Drivers may not be supported by ADOdb project members, or may not contain features (in particular Data Dictionary feature). Drivers may be associated with deprecated or removed PHP drivers.
Access | Firebird | Frontbase Interbase | IBM DB2 | Informix | Microsoft SQL Server | MySQL | Netezza | ODBC | Oracle | PostgreSQL | SAP DB | SQLite | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Verified | No | No | No | Yes | No | No | No | No | No | No | No | No | No |
Sequences | Yes | Yes | Yes1) | Emulated | Emulated | Yes | Yes | ||||||
ADODB_FETCH_BOTH | No | Yes | Yes | Yes | |||||||||
Transactions | No | Yes | Yes | Yes | Yes | Yes | Yes2) | Yes | Yes | Yes | Yes | Yes | Yes |
Record Counting | Emulated | Emulated | |||||||||||
selectLimit() | Emulated3) | Yes | Yes | Yes | |||||||||
Date Offset Functions | No | ||||||||||||
MetaTables Masking | No | No | No | No | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
rowLock row locking | No | ||||||||||||
rowLock column locking | No | ||||||||||||
setCharSet4) | No | No | No | No | No | No | Yes | No | No | No | Yes | No | No |
setConnectionParameter() | Yes | Yes | Yes | Yes | |||||||||
Blob Handling | No | No | No | Yes | No | Yes | No | No | No | No | No | No | No |
Stored Procedures | No | No | No | Yes | No | Yes | No | No | No | Yes | No | No | No |
Performance Monitoring | No | No | No | Yes | Yes | Yes | Yes | No | No | Yes | Yes | No | No |