CONVERT(x, source_char_set, dest_char_set)L Converts x from source_char_set to dest_char_set
--CONVERT(x, source_char_set, dest_char_set) Converts x from source_char_set to dest_char_set. select convert('A B C D E', 'US7ASCII', 'WE8ISO8859P1') from dual;