CONVERT is one of the vital string/char functions of Oracle. It is used to convert a string from one character set to another. The CONVERT function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i.
Syntax:
CONVERT( string, char_set_to , char_set_from )
Parameters:
string: It is used to specify the string to convert.
char_set_to: It is used to specify the character set to convert to.
char_set_from: It is used to specify the character set to convert from.
Example:
CONVERT ( 'Ä Ê Í Õ Ø U', 'US7ASCII', 'WE8ISO8859P1' ) |
Output:
‘A E I ? ? U’
Explanation:
The required string is converted from ISO 8859-1 West European 8-bit character set to US 7-bit ASCII character set.