[htmuoljh]
You can build great websites. We can help! Join today and get access to 3282 training videos: Start a free trial!

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.

Download

tutuploadstutuploadstutuploadsmedia_1295304377292_35a941c19da60c285d8f82668839945d.png
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 "utf8_general_ci". Click Apply and you're done!

 


About the author
Nick is the Director of Support at OSTraining and you can find him in almost every area of the site, from answering support requests and account questions to creating tutorials and software.

You can build great websites. We can help! Join today and get access to 3282 training videos: Start a free trial!

Arvixe

Welcome to training with a smile :) Created by friendly people all across North, Central and South America.