Comparative:
Firebird vs MySQL

FeatureFirebirdMySQL
Version1.5.24.1.0
Referential integrity(1)YesYes(*)
Constraints(2)YesNo
Stored ProceduresYesNo
TriggersYesNo
External FunctionsYes?
Replication(3)NoYes
ODBC DriverYesYes
ADO/.NET DriverYesYes
JDBC DriverYesYes
PHP DriverYesYes
dbExpressYesYes
Online backupsYesYes(*)
Character set handling(4)YesYes
Embedded version(5)YesYes
TransactionsYesYes(*)
ViewsYesNo
Query caching?Yes
SQL-99 Standard ComplianceNot fullNot full
Lock tableNoYes

Legend:

References:

Author: Abel F. Laborda.
Please, report any bug or comment.

You can distribute this document freely.

[Back]