Oracle/PLSQL: AsciiStr Function

In Oracle/PLSQL, the asciistr function converts a string in any character set to an ASCII string using the database character set.

The syntax for the asciistr function is:

asciistr( string )

string is a string in any character set that you want converted to an ASCII string in the database character set.

Applies To:

• Oracle 9i, Oracle 10g, Oracle 11g

For example:

asciistr('A B C Ä Ê')	would return 'A B C \00C4 \00CA'
asciistr('A B C Õ Ø')	would return 'A B C \00D5 \00D8'
asciistr('A B C Ä Ê Í Õ Ø')	would return 'A B C \00C4 \00CA \00CD \00D5 \00D8'