1. Home
  2. Knowledge Base
  3. How To Change MySQL Database Collation?

How To Change MySQL Database Collation?

MySQL Database is named as a relational database management system that runs a server providing multi-user access to a number of databases. It is a Free-software-open source project developed by a community of programmers with a full-featured database management system called MySQL. Collation in MySQL Database is a set of rules used in comparisons. Because many people use MySQL with data to be stored in languages other than English, they need to select the rules of comparisons which in turn depends on the character set used for storing that data. To solve problems related with foreign character encoding you usually change your MySQL collation The most common method to change MySQL collation from latin1 to utf8 can be done by using phpMyAdmin and following the instructions below:

1. Please Enter successful log-in details of your cPanel hosting account and click on the phpMyAdmin icon in the Databases box.

2. Select the database you wish to manage from the drop-down menu on the left.

3. Click on the Operations tab in the top menu of your phpMyAdmin.

4. At the bottom of the page you will see the collation option. You can now select a collation from the drop down menu and click on the Go button.

Updated on 11/04/2020