ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


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
setConnectionParameter() Yes Yes Yes Yes
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 Yes 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
v5/database/feature_comparison.txt · Last modified: 2019/01/22 01:13 by mnewnham