Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 05th, 2009
CONVERT(<char>,<dest_char_set>,<source_char_set>)-- This example illustrates character set conversion by -- converting a Latin-1 string to ASCII. The result is the -- same as importing the same string from a WE8ISO8859P1 -- database to a US7ASCII database.SELECTCONVERT('Ä Ê Í Ó Ø A B C D E ','US7ASCII','WE8ISO8859P1')FROM DUAL;CONVERT('ÄÊÍÓØABCDE'---------------------
A E I ? ? A B C D E ?
/* Common character sets include:
US7ASCII: US 7-bit ASCII character set
WE8DEC: West European 8-bit character set
F7DEC: DEC French 7-bit character set
WE8EBCDIC500: IBM West European EBCDIC Code Page 500
WE8ISO8859P1: ISO 8859-1 West European 8-bit character set
UTF8: Unicode 4.0 UTF-8 Universal character set, CESU-8 compliant
AL32UTF8: Unicode 4.0 UTF-8 Universal character set
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.