Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
Functions, 16 of 121
CONVERT
returns smallest integer greater than or equal to expr.
Converts a character string from one character set to another.
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.
SELECT CONVERT('Groß', 'US7ASCII', 'WE8HP') "Conversion" FROM DUAL; Conversion ---------- Gross
Common character sets include:
US7ASCII
: US 7-bit ASCII character set
WE8DECDEC
: West European 8-bit character set
WE8HP
: HP West European Laserjet 8-bit character set
F7DEC
: DEC French 7-bit character set
WE8EBCDIC500
: IBM West European EBCDIC Code Page 500
WE8PC850
: IBM PC Code Page 850
WE8ISO8859P1
: ISO 8859-1 West European 8-bit character set
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|