How to change 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 cPanel and click on the phpMyAdmin icon in [...]