How can I change my MySQL database collation?

Usually you will be interested in changing your MySQL collation in order to solve problems with foreign character encodings. The most common case is to change your MySQL collation from latin1 to utf8. This can be done by using phpMyAdmin and following the instructions below:

 

1. Enter your cPanel and click on the phpMyAdminicon 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.


Please note that after your change the collation of a database only the new tables will be created with the new collation. All other tables remain with the collation, they were initially created.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Can I change the name of a MySQL database?

The name of a MySQL database consists of a prefix, which is your cPanel username, followed by a...

How can I empty a MySQL database?

The easiest way to empty a MySQL database is through phpMyAdmin.  Once in phpMyAdmin, select the...

How to change the database engine of a MySQL database table?

In this article we will show you how to change the database engine of a MySQL table. Let's...

How to change the MySQL timezone

When you develop your website, you may have to compare a certain date/time with the current...

How to change the password of a Mysql user in cPanel?

If you have already created a MySQL user through the cPanel -> Mysql Databases tool you may...