MySQL Collation Print

You can use phpMyAdmin to alter the collation of mySQL databases,

1. In cPanel, select the phpMyAdmin icon in th Databases subsection.
2. Choose the database that you would like to modify from the drop down menu on the left side of the page.
3. Select the "Operations" tab.
4. The collation option will be at the bottom of the page. Using the dropdown menu, you can choose how the database is collated.

Note: Only new tables will be created with the collation you have chosen - old tables will not be modified. To get around this, re-install or edit the tables and their individual fields. Newly saved databases will have their collation changed.