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

Term: CONVERT

Definition:
The Oracle CONVERT function transforms a given string from one character set to another.

Example Syntax:

CONVERT(<string>, <dest_char_set>, <source_char_set>);


The string is the string to be converted.

The dest_char_set parameter is the character set that the string is to be converted to.

The source_char_set parameter is the character set that the string is to be to converted from.

Example Usage:

SELECT CONVERT('Ä Ê Í Ó Ø A B C D E','US7ASCII','WE8ISO8859P1')
FROM DUAL;


The table below lists the available character sets:

Character Set Description
WE8PC850 IBM PC Code Page 850
US7ASCII US 7-bit ASCII character set
WE8EBCDIC500 IBM West European EBCDIC Code Page 500
WE8DEC West European 8-bit character set
WE8HP HP West European Laserjet 8-bit character set
F7DEC DEC French 7-bit character set
WE8ISO8859P1 ISO 8859-1 West European 8-bit character set


Related Links:

Related Code Snippets:
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 113 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?