====== Feature Comparison Matrix ====== ADOdb features, by Database Type Check that the 'Verified' column is checked before relying on information ===== Driver Support ===== ==== Tier 1 Support ==== 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 Support ==== 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. ==== Compatibility ==== ^ ^ 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 | | [[v5:reference:connection:createsequence|Sequences]] | | | Yes | Yes | | Yes((Emulated in Server 2008 and lower)) | Emulated | | Emulated | Yes | Yes | | | | [[v5:reference:adodb_fetch_mode|ADODB_FETCH_BOTH]] | No | | | Yes | | Yes | Yes | | | | | | | | [[v5:reference:connection:starttrans|Transactions]] | No | Yes | Yes | Yes | Yes | Yes | Yes((Transactional Tables Only)) | Yes | Yes | Yes | Yes | Yes | Yes | | [[v5:reference:connection:recordcount|Record Counting]] | Emulated | | | | | | | | | | | | Emulated | | [[v5:reference:connection:selectlimit|selectLimit()]] | | | | Emulated((Native if query constructed so that TOP n records can be used)) | | Yes | Yes | | | Yes | | | | | [[v5:reference:connection:offsetdate|Date Offset Functions]] | No | | | | | | | | | | | | | | [[v5:dictionary:metatables|MetaTables Masking]] | No | No | No | No | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | | [[v5:reference:connection:rowlock|rowLock row locking]] | No | | | | | | | | | | | | | | [[v5:reference:connection:rowlock|rowLock column locking]] | No | | | | | | | | | | | | | | [[v5:reference:connection:setcharset|setCharSet]]((Superseded by [[v5:reference:connection:setconnectionparameter|setConnectionParameter()]])) | No | No | No | No | No | No | Yes | No | No | No | Yes | No | No | | [[v5:reference:connection:setconnectionparameter|setConnectionParameter()]] | | | | Yes | | Yes | Yes | | | Yes | | | | | [[v5:reference:connection:blobdecode|Blob Handling]] | No | No | No | Yes | No | Yes | No | No | No | No | No | No | No | | [[v5:reference:connection:preparesp|Stored Procedures]] | No | No | No | Yes | No | Yes | No | No | No | Yes | No | No | No | | [[v5:performance:performance_index|Performance Monitoring]] | No | No | No | Yes | Yes | Yes | Yes | No | No | Yes | Yes | No | No |