Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle ASCIISTR Function      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: ASCIISTR

Definition:
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      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 110 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?