1. Knowledge Base
  2. >
  3. Results
  4. >
  5. MySQL Collation

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:

  1. Log in to cPanel
  2. In the Databases section, click phpMyAdmin.

    HostGator cPanel phpMyAdmin

  3. In the left pane, select the database you wish to manage from the dropdown menu.

    phpMyAdmin Database

  4. On the top menu bar, click on the Operations tab.

    phpMyAdmin Operations Tab

  5. At the bottom of the page, you will see the Collation option. You can now select a collation from the dropdown menu and then click Go.

    phpmyadmin collasion tab

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:

  1. Log in to cPanel
  2. In the Databases section, click phpMyAdmin.

    HostGator cPanel phpMyAdmin

  3. In the left pane, click the + icon next to the name of the database that contains the table you want to modify.
  4. Click the name of the table you want to alter.
  5. On the top menu bar, click Operations.

    phpmyadmin operations tab

  6. Under Table options, in the Collation list box, select the collation that you want for the table, and then click Go.

    phpmyadmin collasion tab