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

Term: UNISTR

Definition:
The UNISTR function converts a string to the national character set (either UTF8 or UTF16). For portability and data preservation, you should specify only ASCII characters and the Unicode encoding values UNISTR() string argument.

Example Syntax:

UNISTR(ch VARCHAR2 CHARACTER SET ANY_CS) RETURN NVARCHAR2;


Example Usage:

SELECT UNISTR(ASCIISTR(CHR(128) || 'Hello' || CHR(255)))
FROM DUAL;



Related Links:

Related Code Snippets:
  • UNISTR - Takes a text literal (or an expression that resolves to character data) and returns it in...
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 223 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?