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:
- Enter your Site Tools > MySQL > phpMyAdmn;
- Select the database you wish to manage from the drop-down menu on the left.
- Click on Operations in the top menu of your phpMyAdmin.
- At the bottom of the page, you will see the collation option. Select a collation from the drop-down menu and click on Go.
Note 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.
For the convenience of their customers, most web hosts have set MySQL’s collation to utf8 by default.