ESDS Knowledge Base


How can I change my MySQL database collation?

Generally you would require to change your MySQL collation so as to solve any problems with foreign character encodings. The very common step that can be taken here is to change your MySQL collation from latin1 to utf8. The same can be changed by using phpMyAdmin and the by following the below mentioned steps :

1. First you need to login to your cPanel account provided with your web hosting account and then click on phpMyAdmin icon located in the Database Box.

2. Now you need to select the Database you would want to manage from the drop down menu located on the left.

3. Then click on the Operations tab in the top menu of your phpMyAdmin

4. Once you click on Operations you will see at the bottom of the page the collation option. You need to now select a collation from the drop down menu and click on the Go button.

Please be informed that after you change the collation of a database only the new tables will be created with the new collation.  All the other tables will remain with the collation, they were initially created with.

Leave a Reply