How to Modify the Collation for a Table using phpMyAdmin in cPanel

March 10, 2023 / MySQL

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.

Let us follow the steps to modify the collation for a table using phpMyAdmin in cPanel:

  1. Log in to cPanel.
  2. Select the “phpMyAdmin” option under “Database” section.
    database
  3. Select the database from the left-hand side menu.
    phpmyadmin
  4. You will enter an interface where you will find tables. Select a particular table and click on the “Operations” button.
    operations
  5. You will find the option “Collation” under “Table options” section.
    table options
  6. Select the type of collation as shown below.
    table options-collation
  7. Click on “Go” button.
    go
  8. You will get a success message.
    SQL

Was it not simple? We sincerely hope you enjoyed reading our article and will return soon for more insightful content. For any help, get in touch with our support staff.

Spread the love