Change MySQL database collation

April 11, 2011 / MySQL

How to change the MySQL database collation ?

Few webmasters come asking such questions wherein they have a requirement to change the MySQL collation to overcome issues related to encoding of foreign characters. The best method to do it is make amendments to the MySQL collation from ‘latin1‘ to ‘utf8‘.

Below is the procedure to change MySQL database collation in PhPMyAdmin :

Step A : Login to cPanel control panel

Step B : Go to the phpMyAdmin


Step C : Choose the database for which you intend to make the changes

Step D : Hit the ‘Operations’ option

Step E : On this page, you should be able to located the ‘Collation‘ option

Step F : You can see a drop-down menu, here you need to choose the collation type

Step G : Hit ‘Go

One must take into account that, this would only make changes to the collation of your database for all the newly created or upcoming tables, while the previous would be left as-it-was.

Note: Before making any changes, it is strongly advisable to maintain the latest back-up of the database. To learn the procedure to take backup of your database, please visit : Backup Database from PHPMyAdmin

Spread the love