The Oracle ASCIISTR function takes a string (or an expression that resolves to a string), in any and returns an ASCII version of the string in the current database character set.
The ASCIISTR function is useful for taking strings with accented characters (such as strings containing unicode characters) and converting them to an "ASCII-safe" format.
SELECT ASCIISTR('The letter Å will be converted.') asc_str
This example returns the following string:
The letter \00C5 will be converted.
Related Code Snippets:
- ASCIISTR - ASCIISTR takes as its argument a string, or an expression that resolves to a string, in...