How to change Database Collation in MySQL Server from phpMyAdmin?

Collation is a configuration level setting in the MySQL. It directs how the character data will be handled by the MySQL Database with in the server, database, or column level.

You can change the Database Collation using the SQL Commands as well as from GUI. Following are the steps to change the Collation for a Database in MySQL from phpMyAdmin.

Note: Consult your Database/Web Developer before making these changes.

  1. Log in to the phpMyAdmin.

  2. Select your Database and click on the Operations Button.



  3. Select the required Collation from the Collation Drop-Down.



  4. Click on the Go Button.

You have changed the Database Collation successfully.

  • 0 Users Found This Useful

Was this answer helpful?

Related Articles

How to change storage engine of a MySQL database table?

Following article describes the steps to change storage engine of a MySQL database table. Assume...

How to Display Actual Error in Magento Website?

You may have seen following errors when Magento do not work properly for some reason. These...

What is the location of AccuWebHosting.com Datacenters?

We host all our shared servers (Shared Web, Database and Email server), all Linux and Windows...

How to Install Drupal Manually?

We offer one-click installer Softaculous to our Linux Shared Hosting customers to install popular...

How do I change document root folder to some sub-folder using an .htaccess file?

By default the web-contents of your website will be loaded from public_html directory. If you...