Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-01 |
|
Functions, 7 of 177
asciistr::=
ASCIISTR
takes as its argument a string in any character set and returns an ASCII string in the database character set. The value returned contains only characters that appear in SQL, plus the forward slash (/). Non-ASCII characters are converted to their Unicode (UTF-16) binary code value.
See Also:
Oracle9i Database Globalization Support Guide for information on Unicode character sets and character semantics |
The following example returns the ASCII string equivalent of the text string "ABÄCDE
":
SELECT ASCIISTR('ABÄCDE') FROM DUAL; ASCIISTR('FLAUW --------------- AB\00C4CDE
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|