Admin Tools - The Quick and Easy Way to Change Database Collation in Joomla

April 25, 2011 | Joomla Tutorials | Written by Nick Savov

A common problem experienced while using Joomla extensions is the infamous "Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=SELECT......." This is something that can be quite tricky for a new Joomla user to fix, however not any more. This tutorial will walk you through step-by-step how to fix a database collation problem the quick and easy way using Admin Tools by Akeeba.

Download

tutuploadstutuploadstutuploadsmedia_1295304377292_35a941c19da60c285d8f82668839945d.png

Go to http://www.akeebabackup.com/download/admintools/ and then View files.

tutuploadstutuploadstutuploadsmedia_1288738580353_41855a1aa03426cc661ae2ed5aa64474.png

Download now

Install

tutuploadstutuploadstutuploadsmedia_1288739131664_f999fa12e94f17c9de80dbe98ed2b880.png

In your site's administrator area, go to Extensions >> Install/Uninstall, click Browse to find the file and click Upload File & Install to complete the upload.

Change Database Collation

tutuploadstutuploadstutuploadsmedia_1288739303330_7cf2e6d3c414735ae835dd634a4aa481.png

In your site's administrator area, go to Components >> Admin Tools

Click on Change Database Collation.

It's generally recommended to use "utf8_general_ci". Click Apply and you're done!

Add comment

Start Online Training

Members get access to all our video training. That's 1,244 training sessions in Joomla, Drupal, WordPress and Coding.

Blog Categories

Latest Comments

HikaShop - Ecommerce for Joomla
Comment by davidmc4

Hello Guys! The scattererbraine d Hikashop docs are the worst I have ever seen in ...
Magic Quotes Error With Joomla 3 Installation
Comment by thor

MYUSERNAME it's meant username that you used to log-in into your hosting website ...
Change Drupal Usernames with the Real Name Module
Comment by steve

Thanks Danny. This member had actually been poking in the code trying to make this ...
Change Drupal Usernames with the Real Name Module
Comment by Danny

Nice! Just FYI, there is also a handy hook you can use to alter the display of usernames ...
Embed YouTube Videos in Joomla 2.5 and 3
Comment by Jorge Popel

I installed this plugin. It is wonderfull.

The License for Our Tutorials

All of our tutorials are published under the Creative Commons Attribution-NonCommercial license. This means:

You can re-use these tutorials.
You can modify these tutorials.
You must link back to our original tutorial.
You can't use these tutorials commercially.

Click here to read the full license.

Joomla Tutorials and Blog Posts