MySQL Collation
You can change the collation settings of a MySQL database and tables using phpMyAdmin.
Changing the Default Collation for a Database
To change the collation for a database, follow the instructions below:
- Log in to cPanel.
- In the Databases section, click phpMyAdmin.
- In the left pane, select the database you wish to manage.
- On the top menu bar, click on the Operations tab.
- At the bottom of the page, you will see the Collation option. You can now select a collation from the dropdown menu and click Go.
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.
Changing the Collation for a Table
To change the collation for a database, follow the instructions below:
- Log in to cPanel.
- In the Databases section, click phpMyAdmin.
- In the left pane, click on the database name that contains the table you want to modify.
- Click the name of the table you want to alter.
- On the top menu bar, click Operations.
- Under Table options, in the Collation list box, select the collation that you want for the table, then click Go.