In Oracle/PLSQL, the compose function returns a Unicode string.
The syntax for the compose function is:
compose( string )
string is the input value used to create the Unicode string. It can be a char, varchar2, nchar, nvarchar2, clob, or nclob.
Below is a listing of unistring values that can be combined with other characters in the compose function.
Unistring Value | Resulting character |
unistr('\0300') | grave accent ( ` ) |
unistr('\0301') | acute accent ( ´ ) |
unistr('\0302') | circumflex ( ^ ) |
unistr('\0303') | tilde ( ~ ) |
unistr('\0308') | umlaut ( ¨ ) |
Applies To:
- Oracle 9i, Oracle 10g, Oracle 11g
For example:
compose('o' unistr('\0308') ) | would return ö |
compose('a' unistr('\0302') ) | would return â |
compose('e' unistr('\0301') ) | would return é |
