CONVERT converts the string argument from one character set to another one.
The source_set argument specifies the character set of the stored data in the database if ‘string’ is a column name, or the character set of ‘string’ if it is an argument to the function.
‘Destination_set’ is the character set you want to convert to.
SELECT CONVERT(‘go to UTF8 from ascii’,’UTF8′,’US7ASCII’) as RESULT from DUAL;
go to UTF8 from ascii