You can change the collation of a MySQL database by using phpMyAdmin and following the instructions below:
- Enter your cPanel and click on the phpMyAdmin icon in the Databases box.
- Select the database you wish to manage from the drop-down menu on the left.
- Click on the Operations tab in the top menu of your phpMyAdmin.
- At the bottom of the page you will see the collation option. You can now select a collation from the drop down menu and click on the Go button.
Please note that after your change the collation of a database only the new tables will be created with the new collation. All other tables remain with the collation, they were initially created.
