|Oracle® Database SQL Language Reference
11g Release 2 (11.2)
Part Number E17118-03
ASCIISTR takes as its argument a string, or an expression that resolves to a string, in any character set and returns an ASCII version of the string in the database character set. Non-ASCII characters are converted to the form
xxxx represents a UTF-16 code unit.
See Also:Oracle Database Globalization Support Guide for information on Unicode character sets and character semantics
The following example returns the ASCII string equivalent of the text string "
SELECT ASCIISTR('ABÄCDE') FROM DUAL; ASCIISTR(' ---------- AB\00C4CDE