MySQL Collation

You can change the collation of a MySQL database by using phpMyAdmin and following the instructions below:
  1. Enter your cPanel and click on the phpMyAdmin icon in the Databases box.
  2. Select the database you wish to manage from the drop-down menu on the left
  3. Click on the Operations tab in the top menu of your phpMyAdmin
  4. 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.