CONVERT(char, dest_char_set [,source_char_set] )
Converts a character string from one character set to another.
The char argument is the value to be converted.
The dest_char_set argument is the name of the character set to which
char is converted.
The source_char_set argument is the name of the character set in
which char is 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.
Common character sets include:
US 7-bit ASCII character set
DEC West European 8-bit character set
HP West European Laserjet 8-bit character set
DEC French 7-bit character set
IBM West European EBCDIC Code Page 500
IBM PC Code Page 850
ISO 8859-1 West European 8-bit character set
SELECT CONVERT('Grob','WE8HP','WE8DEC') "Conversion"