Admin Tools - The Quick and Easy Way to Change Database Collation in Joomla
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.
Go to http://www.akeebabackup.com/download/admintools/ and then View files.
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
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!