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

Do you support PHP on your Servers? If yes, is it automatically available OR do I have to request for it?

PHP is available on all our Windows shared hosting and Linux shared hosting. You just need to...

How to Change PHP Version From cPanel?

This article will assist you to change PHP version from cPanel. Please note that the option of...

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...

When I connect to FTP account through filezilla it always says certificate is unknown. What am I missing here?

This error is common because FTP service of our shared server is bound with server's Self-Signed...

Can I upgrade my shared hosting plan to VPS hosting?

Shared hosting plan cannot be upgraded to VPS hosting directly. You can purchase a separate VPS...