How to Change MySQL Collation Settings using PHPMyAdmin

Web Hosting in Pakistan

This article describes how to use phpMyAdmin to change the collation settings for MySQL databases and tables.


About Character Sets and Collation

MySQL enables you to store and process data in a wide variety of languages using various character sets. For some operations, such as comparing two strings, MySQL uses a set of rules to determine equality and sorting order. This set of rules is known as a collation.

You may have to change the collation for a database or table based on the character set you want to use for string data. You can do this by using the phpMyAdmin tool in cPanel.


Changing the Default Collation for a Database

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

  1. In the Databases section of the cPanel home screen, click phpMyAdmin. The phpMyAdmin administration page appears in a new window.
  2. In the left pane, click the name of the database you want to modify.
  3. On the top menu bar, click Operations.
  4. Under Collation, select the collation that you want for the database, and then click Go.

    • This setting only affects new tables that you create. Any existing tables maintain their current collation setting.


Changing the Collation for a Table

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

  1. In the Databases section of the cPanel home screen, click phpMyAdmin. The phpMyAdmin administration page appears in a new window.
  2. 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.
  3. Click the name of the table you want to modify.
  4. On the top menu bar, click Operations.
  5. 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?

 Print this Article

Also Read

How to Use PHPMyAdmin to Copy a MySQL Database

This article describes how to copy a MySQL database using phpMyAdmin. Copying a MySQL Database...

How to Manage MySQL Databases and Users in cPanel

This article describes how to use cPanel to manage MySQL databases and users. You can add,...

How to Optimize and Repair MySQL Databases using PHPMyAdmin

This article describes how to optimize and repair MySQL databases using phpMyAdmin. Optimizing...

How to Configure Remote MySQL Access in CPanel

This article describes how to use cPanel to allow external hosts to access your MySQL databases....

Becoming Familiar with Databases in phpMyAdmin

We are going to assume that you are logged in to phpMyAdmin.The main screen is divided into two...

Web Hosting in Pakistan

Powered by WHMCompleteSolution