Collation and Engine - Changer

Get Collation and Engine - Changer (v1.0)

Introduction

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

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.

Write a review

Does Exactly What It Says It Does - Quickly!

Paul Roche (2).
Posted on 19 June 2017

Functionality

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

Support

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

Documentation

Multilingual support!

Value for money

Easy. Saved a

I used this to: Keeping legacy Joomla extensions in line with future requirements

Great program and excellent support

John Candido (1).
Posted on 01 May 2016

Functionality

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.

Support

Incredible Support. Matthias helped with converting both Joomla sites daily for over a week due to my problems giving him cpanel access.

Documentation

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.

Display #

Paid download

SEO-Generator

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

Paid download

Article-Generator

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

Paid download

ALIAS-Generator

By MCTrading

SEF

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