Syntax
asciistr::=
Text description of asciistr
Purpose
ASCIISTR takes as its argument a string in any character set and returns an ASCII string in the database character set. The value returned contains only characters that appear in SQL, plus the forward slash (/). Non-ASCII characters are converted to their Unicode (UTF-16) binary code value.
Examples
The following example returns the ASCII string equivalent of the text string "ABÄCDE":
SELECT ASCIISTR('ABÄCDE') FROM DUAL;
ASCIIS
------
ABDCDE
