You may also use CAST() to convert a string to a different character set. The syntax is: CAST( character_string AS ...
dev.mysql.com