Change MySQL result character set

If you have data saved in MySQL as ISO8859-1 and you want to converted it to UTF8. You can change the character set of your connection with the following query:

SET CHARACTER SET UTF8