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. Old tables remain with the collation from when they were created.
How can I get around that? In phpMyAdmin, click the "Operations" tab for that database and check what collation is set, then re-install or simply edit the tables and their individual fields. Anything you install will pick up that collation, for the table and individual fields.
