Migration & Conversion, Data Import & Export, Hosting, Database Management, Joomla Migration

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".

  • Favourite
  • Report

The "Collation and Engine - Changer" can be used to switch the Database Collation and Database Character set including all tables and columns to UTF8mb4 (or to an other collation). It will also converting all tables from MyISAM to InnoDB. In this way you are using the same like Joomla 3.5 is doing for the core tables. All this can be easily done from your Joomla backend.

Whenever you have one of these problems:

  • you have to switch from one collation to an other
  • you have to switch from MyISAM to InnoDB
  • you got the error: "Illegal mix of collations"
  • you have to migrate an website from Joomla 2.5 to 3.5
  • you are using extensions that are not using UTF8mb4

then the CE-Changer is your solution.

Every Joomla site may well need this to keep database tables in line.
Ease of use
Once configured, this is click and go. Job Done
Configuration may be tricky for those who haven't configured my.conf before
Matthias has a day job and works hard at it. If there's a glitch (as there was in activating my subscription) he's on it as soon as possible
Multilingual support!
Value for money
Easy. Saved a
I used this to: Keeping legacy Joomla extensions in line with future requirements
I purchased CE-Changer to convert my data tables from MyISAM to InnoDB in my two Joomla sites -both of which date back to version 1.5.
Ease of use
The programme was easy to use. I had trouble configuring the MySQL file my.cnf with an old version of MySQL.
Incredible Support. Matthias helped with converting both Joomla sites daily for over a week due to my problems giving him cpanel access.
Instructions were clear and easy to understand with additional help always available..
Value for money
This is a great low cost way to switch to the innodb engine and Matthias is there every step of the way if you need help. Highly recommended
I used this to: Only four tables could be not switched to innodb because of my old version of mysql.
Before MySQL 5.6 Full-Text Search is supported only with MyISAM Engine.
SEO-Generator SEO-Generator
Paid download


By MCTrading
SEO & Metadata
SEO-Generator is a SEO extension for Joomla, which automatically generates keywords and description for each article by pulling text from the title and/or the content, to help with SEO. It also gives you the ability to set different title configurations, robots meta tags and google webmaster verification keys. Joomla provides a great system for including metadata keywords and description on articl...
Article-Generator Article-Generator
Paid download


By MCTrading
Social Edition
Article-Generator is a SEO extension for Joomla, which automatically generates new articles with own keywords by pulling text from any feed-source you want, to help with SEO. It gives you the ability to set many different configurations for each feed-source. It keeps you’re site fresh and gives you’re visitors something to read and you have nothing to do. All is done by an cronjob - every 5 mi...
ALIAS-Generator ALIAS-Generator
Paid download


By MCTrading
This native Joomla 2.5 and 3.x plugin automatically generates new aliases for all your joomla articles in one step by using the title from each article. It gives you the ability to choose between the joomla transliteration aliases or joomla unicode aliases. Joomla provides a great system for creating aliases for each article by using the article-title. But if you need to change between transliter...

Collation and Engine - Changer

Last updated:
Apr 09 2016
Date added:
Mar 28 2016
GPLv2 or later
Paid download

This extension does NOT implement the Joomla! Update System


Write a review