This is an old revision of the document!

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		Yes¹⁾	Emulated		Emulated		Yes	Yes					No
ADODB_FETCH_BOTH	No		No			Yes		Yes	Yes										No
Transactions	No	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes²⁾	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	Yes
Record Counting	Emulated		No														Emulated		No
selectLimit()			No			Emulated³⁾		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
setCharSet⁴⁾	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

¹⁾

Emulated in Server 2008 and lower

²⁾

Transactional Tables Only

³⁾

Native if query constructed so that TOP n records can be used

⁴⁾