Purpose
This function converts a string from any character set to an ASCII string using the database character set.
Non-ASCII characters are converted to the \xxxx format, where xxxx represents the UTF-16 code unit.
Syntax
ASCIISTR(char)
Parameters
The char parameter is a string in any character set.
Return type
The function returns a string value.
Examples
Convert the string A B C ＠ Ä Ê Í Õ Ø to an ASCII string.
obclient> SELECT ASCIISTR('A B C ＠ Ä Ê Í Õ Ø') FROM DUAL;
+-------------------------------------------+
| ASCIISTR('ABC＠ÄÊÍÕØ') |
+-------------------------------------------+
| A B C \FF20 \00C4 \00CA \00CD \00D5 \00D8 |
+-------------------------------------------+
1 row in set