The Joomlashack Blog

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

Written by Nick Savov Nick Savov
Published: 25 April 2011 25 April 2011

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 https://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

 

tutuploadstutuploadstutuploadsmedia_1303712844370.png

Click on Change Database Collation.

 

tutuploadstutuploadstutuploadsmedia_1303712983297.png

It's generally recommended to use "UTF-8 multibyte". Click Apply and you're done!