Changing the Database Collation in PhpMyAdmin
A collation is a set of rules that defines how to compare and sort character strings. Every character set has at least one collation. The default character set for MySQL is latin1, with a default database collation of latin1_swedish_ci. You can also change the encoding to utf8 which is a is a common character set for non-Latin characters. The most common case is to change your MySQL collation from latin1 to utf8. This can be done by using phpMyAdmin and the steps are given below:
1) Login to your cPanel.
2) Navigate to Databases > PhpMyAdmin.
3) Select the database.
4) Click on “Operations” from the top set of tabs.
5) In the Collation box, choose your new collation from the drop-down menu. utf8_general_ci is the most common utf8 collation.
6) Then click the button “Go”.
You can also change the settings via command line:
1) Log into MySQL with SSH:
# mysql -u admin -p password
2) Enter your database password when prompted.
3) Run the following command to change the character set and collation of your database:
# ALTER DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;
If you need any further help please do reach our support department.
