Knowledge Base
MilesWeb / Database

Learn to change MySQL collation settings in phpMyAdmin

Approx. read time : 3 min

This article explains how to change the collation settings for MySQL databases and tables using phpMyAdmin.

You can store and process data in different variety of languages using various character sets through MySQL.
For some of the operations like a comparison of two strings, MySQL uses a set of rules that determine the quality and the type of sorting order. This set of the rule is called as collation.

To change the collation for a database or table based on the character set on which you want to use string data, you can use phpMyAdmin tool in cPanel.

# Steps to change default collation for the database

1. Log in to cPanel account.

2. In the cPanel home screen go to the Databases section and click on phpMyAdmin.

Now, the phpMyAdmin administration page will appear in a window.

3. On the left side of the panel, click on the name of the database that you want to modify.

4. Click on Operations at the top of the menu bar.

5. Under the Collation, select the collation that you want for your database, and then click on Go.

# Steps to change the collation for a table

1. Log in to cPanel.

2. In the cPanel home screen, go to the Databases section and then click on phpMyAdmin.

Now, the phpMyAdmin administration page window will appear.

3. In the left side of the panel, click on the + icon that is next to the name of the database and contains the table that you want to modify. phpMyAdmin will expand the view to show the database’s tables.

4. Click on the name of the table that you want to modify.

5. Click on Operations, in the top menu bar.

6. Under the Table options, in the list box for Collation, select the collation that you want for the table and then click on Go.

Also Read :

1)How to search MySQL tables in phpMyAdmin?

With an interest in doing something creative daily, Sonam works as a Digital Marketing Executive. She likes to write technical blogs related to web hosting, digital marketing, and other IT topics. She also likes to spend her leisure time on social media to find different strategies for client engagement.

Trusted By Thousands of Clients & Big Businesses

We highly appreciate the kind and stellar feedback we receive from our customers. Delivering the best is our goal! MilesWeb is rated Excellent out of 5 based on reviews. Read more reviews.

Excellent
Based on reviews
2 hours ago
Perfect and Valuable Server + ...
I am using MilesWeb Servers, The main thing which I getting are continuous support over everything w...
Gunjan Makwana
4 hours ago
Milesweb is superb Hosting pro...
Milesweb is superb Hosting provider ever, their Support team is amazing!!!...
Abhishek Singh
15 hours ago
Great support in great timing...
We need urgent assistance on changes in a primary domain on our client's Cpanel accounts and reached...
Riyaju Deen
21 hours ago
Best Website Hosting platform ...
I was new on MilesWeb. And needed help on multiple areas from setting up to getting started with cre...
Harshada
1 days ago
Very quick and helpful assista...
Very quick and helpful assistance. Support person listened properly and provided a nice solution....
Narendra
1 days ago
the team is very supportive th...
the team is very supportive though at times effort needs to be made to make understand the problem s...
Suree Sharma
1 days ago
I am using miles web for 3plus...
I am using miles web for 3plus years, very quick and perfect support by the team, they helped me man...
Sri Raghav
2 days ago
The service is good...
The service is good. They are answering with patience and doing the needful as soon as possible....
MR
2 days ago
Perfect and Valuable Server + ...
I am using MilesWeb Servers, The main thing which I getting are continuous support over everything w...
Gunjan Makwana
3 days ago
Very quick and helpful assista...
Very quick and helpful assistance. Support person listened properly and provided a nice solution....
Narendra
4 days ago
positively helped me with find...
positively helped me with finding insecure content on my website causing SSL to not work properly on...
Thaviraj Junglee
4 days ago
Exceptional support, Truly Pra...
I had opted for the basic wordpress hosting plan as I intended to experiment with various plug-ins. ...
Aseem Chandna