How to change the MySQL collation settings in phpMyAdmin Print

cPanel, phpMyAdmin
0

Changing the default collation for a database

To change the default collation for a database, follow these steps:

Log in to cPanel.
If you do not know how to log in to your cPanel account, please see this article.
In the DATABASES section of the cPanel home screen, click phpMyAdmin.
The phpMyAdmin administration page appears in a new window.
In the left pane, click the name of the database you want to modify.
On the top menu bar, click Operations.
Under Collation, select the collation that you want for the database, and then click Go.

Changing the collation for a table

To change the collation for a database table, follow these steps:

Log in to cPanel.
If you do not know how to log in to your cPanel account, please see this article.
In the DATABASES section of the cPanel home screen, click phpMyAdmin.
The phpMyAdmin administration page appears in a new window.
In the left pane, click the + icon next to the name of the database that contains the table you want to modify. phpMyAdmin expands the view to show the database's tables.
Click the name of the table you want to modify.
On the top menu bar, click Operations.
Under Table options, in the Collation list box, select the collation that you want for the table, and then click Go.

Was this answer helpful?

Related Articles

How to use phpMyAdmin to copy a MySQL database To copy a MySQL database using phpMyAdmin, follow these steps: Log in to cPanel. In the... How to optimize and repair MySQL databases using phpMyAdmin Optimizing MySQL databases Databases have the potential to grow very large, particularly on... How to access phpMyAdmin in cPanel To access phpMyAdmin: Log in to cPanel. In the DATABASES section of the cPanel home screen,...