ASCIISTR

Oracle

ASCIISTR(string)

• string: This parameter represents the string to be converted. It takes an NVARCHAR2 character as input and converts it to an ASCII string in the database character set. The input can represent any string whether it’s a single character, a word, a sentence, or an entire paragraph. Special characters are represented in output with their Unicode code-point value in the form of ’ nnnn’ or ’\+nnnnnnn’.

Example

SELECT ASCIISTR('Employee: Olé') FROM dual;

Output

'Employee: \00F3l\00E9'

Explanation

The ASCIISTR function returns an ASCII version of the input string, allowing it to display special characters in Unicode escape format. In this example, the special characters in “Olé” are replaced with their Unicode representations \00F3 and \00E9.