You can change the collation of a MySQL database by using phpMyAdmin:
- Log into cPanel
-
Click PHPMyAdmin, from the Databases section

-
In the Recent Tables menu in the left sidebar, click the name of the database you want to manage from the drop-down menu
-
Click the Operations tab, near the top of the page

- In the Collation section on the right select your desired collation from the drop-down menu
-
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:
-
While in PHPMyAdmin in cPanel, select the database you want to manage from the drop-down in the Recent Tables sidebar
-
Check which collation is set via the Collation section
-
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
|