Support Center

Change the Collation of a MySQL Database

Last Updated: Aug 24, 2015 04:17PM CDT

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
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found