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.
