In this article, you will learn how to modify the collation for a table using phpMyAdmin in cPanel. A collation is a set of rules that defines how to relate and sort character strings.
Follow the steps:
- Log in to cPanel.
- Select the “phpMyAdmin” option under the “Database” section.

- Select the database from the left-hand side menu.

- You will enter an interface where you will find tables. Select a particular table and click on the “Operations” button.

- You will find the option “Collation” under the “Table options” section.

- Select the type of collation as shown below.

- Click on the “Go” button.

- You will get a success message.

We hope this guide was easy to follow and helpful. Feel free to visit us again for more informative content. If you need any assistance, our support team is always ready to help.