You can change the collation of a MySQL database by using phpMyAdmin:

1. Log into cPanel

2. Click PHPMyAdmin, from the Databases section
   
   ​

3. In the Recent Tables menu in the left sidebar, click the name of the database you want to manage from the drop-down menu

4. Click the Operations tab, near the top of the page
   
   

5. In the Collation section on the right select your desired collation from the drop-down menu

6. Click the Go button​
   
   

After you change the collation of a database, only the newly-created tables will be created with the new collation specification. Old tables remain collated as they originally were. You can get around this in PHPMyAdmin:

1. While in PHPMyAdmin in cPanel, select the database you want to manage from the drop-down in the Recent Tables sidebar

2. Check which collation is set via the Collation section

3. Re-install the old tables, or simply edit the tables and their individual fields; anything you install will pick up that new collation specification, for the table and individual fields