Oracle - PL/SQL - 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'