|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-01
Functions, 22 of 177
CONVERT converts a character string from one character set to another. The datatype of the returned value is
charargument is the value to be converted. It can be any of the datatypes
dest_char_setargument is the name of the character set to which
source_char_setargument is the name of the character set in which
charis stored in the database. The default value is the database character set.
Both the destination and source character set arguments can be either literals or columns containing the name of the character set.
For complete correspondence in character conversion, it is essential that the destination character set contains a representation of all the characters defined in the source character set. Where a character does not exist in the destination character set, a replacement character appears. Replacement characters can be defined as part of a character set definition.
The following 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.
SELECT CONVERT('Ä Ê Í Õ Ø A B C D E ', 'US7ASCII', 'WE8ISO8859P1') FROM DUAL; CONVERT('ÄÊÍÕØABCDE' --------------------- A E I ? ? A B C D E ?
Common character sets include: