Collation and Engine - Changer

This Joomla 2.5 and 3.x plugin changing automatically the Database Collation and Database Character set including all tables and columns. It will also converting tables from MyISAM to InnoDB. The new Joomla 3.5 is designed to work with the UTF8mb4 collation and the InnoDB Engine of MySQL. This collation allows you to use Emoji and other multibyte characters such as certain Traditional Chinese glyphs, Cherokee etc. In this case you need to change the collation to “UTF-8 Multibyte”. Joomla 3.5 is doing this for all the own core tables while upgrading to the newest Joomla Version. But you may need to repeat that step for all the "old" extensions or after installing or upgrading extensions which are using other collation. After installing new extensions you are strongly advised to check this. If an extension involves fields with different collations then this could end in an error like: "Illegal mix of collations".