Important note: With the 12.0 release we changed registration keys. The new key is available for registered users from our Customer Portal. Users upgrading from a pre-12.0 version should have the new key available before installing. Until SQLyog 12.x is registered with the proper key, it will only display the registration dialog.
Changes (as compared to SQLyog MySQL GUI 12.01) include:
* Exports to CSV and Excel XML can now optionally include BOMs (Byte Order Marks) or not. Before this, BOMs were not an option. Some Windows programs will require BOMs in order to recognize the encoding as UTF8.
* The fix in 11.3 for databases named identically except for lettercase would fail in some cases. One such case was if database default charset was utf8mb4.
* The checkbox in CREATE/ALTER TABLE dialog for setting ON UPDATE CURRENT_TIMESTAMP failed for TIMESTAMP and DATETIME columns using fractional seconds. MySQL 5.6+ from Oracle was affected. MariaDB 10 was not.
* Also in in CREATE/ALTER TABLE dialog, for TIMESTAMP and DATETIME columns using fractional seconds a default specified as CURRENT_TIMESTAMP(n) (with ‘n’ being a number in the range 1..6) was incorrectly ‘quoted’ and thus failed.