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

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 |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org