Re: MySql Vs Firebird

[Barry Galbraith]

Firebird can do Case Insensitive search only if you use UTF-8 character set.
MySQL allows Case Insensitive collations on most character sets, so you search for "abcd" and it will find "ABCD", "AbCd" etc.

Firebird has a tiny set of builtin functions which I find to be poorly documented.
MySQL has a large collection of builtin functions which are clearly documented.

Firebird can do incremental backups, but you can only restore to a backup time. Any changes since the backup are lost on restore from backup.

MySQL does backups, and with binary logging enabled you can do point-in-time restore, to get back to the exact time of the failure.

My 2c worth.

Good Luck.



Edited 1 time(s). Last edit at 03/07/2009 05:50PM by Barry Galbraith.