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

A subdomain that I have created isn't working.

Please note that subdomain requires DNS propagation and it may take upto 24 hours. If DNS...

How to Manage Shared cPanel Account from Client Area?

This article will assist you to manage your Shared linux cPanel account from client area. At...

How to add new domain for emails only?

Free Mailbox With Domain Registration You can get one FREE mailbox by registering your domain...

Where do I upload my files/folders in Shared Hosting plans?

All the files associated with your website must be placed inside the root folder of your domain....

How Much Email Disk Space Do I Get With Shared Hosting Plans?

Linux Shared Hosting With Linux Shared Hosting plans, you don't have separate email diskspace....