Change MySQL database collation

999sam · #1 (**permalink**) 12-28-11, 03:18

I am facing some issues with MySQL database collation, so I want to change my MySQL database collation.
How can I do that?

77wmaster · #2 (**permalink**) 12-28-11, 04:21

Normally users interested in changing their MySQL collation in order to solve issues with foreign character encodings. Generally it changes your MySQL collation from latin1 to utf8.

WebMaster · #3 (**permalink**) 12-28-11, 05:40

To change your MySQL database collation, you have to follow the following steps :

A. Enter your cPanel and click on the phpMyAdmin icon in the Databases box.

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

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

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

You have to keep in mind that after you 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.