The ASCIISTR function takes a string in any character set and returns an ASCII version of that string.
How ASCIISTR Converts Non-ASCII Characters
The ASCIISTR function converts non-ASCII characters to \
xxxx
, where xxxx
represents a UTF-16 code unit.
See:
Oracle Database Globalization Support Guide for information on Unicode character sets and character semantics.