If you have created a website and forgot to set the charset to UTF-8 and it has defaulted to Latin-1 then follow the instruictions below.
- First make a back up of the database.
- Find the line(s) that contains "SET NAMES latin1" and change that to "SET NAMES utf8".
- Then, look at the table definition(s) and change "DEFAULT CHARSET=latin1" to "DEFAULT CHARSET=utf8".
- Save the database
- Set operations in phpmyadmin to UTF-8 (utf8_general_ci),
- Reimport the database to the website