Quick Search:
 The Oracle ASCIISTR Function      [Return To Index] Jump to:  


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.

Example Usage:

SELECT ASCIISTR('The letter Å will be converted.') asc_str
FROM dual;

This example returns the following string:

The letter \00C5 will be converted.

Related Links:

Related Code Snippets:
  • ASCIISTR - ASCIISTR takes as its argument a string, or an expression that resolves to a string, in...
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org