MySQL Collation | HostGator Support
  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.

    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 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 on the database name that contains the table you want to modify.
    phpMyAdmin database
  4. Click the name of the table you want to alter.
    phpMyAdmin table
  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, then click Go.

    phpmyadmin collasion tab