Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 137 of 166
to_multi_byte::=
to_multi_byte
TO_MULTI_BYTE
returns char
with all of its single-byte characters converted to their corresponding multibyte characters. char
can be of datatype CHAR
, VARCHAR2
, NCHAR
, or NVARCHAR2
. The value returned is in the same datatype as char
.
Any single-byte characters in char
that have no multibyte equivalents appear in the output string as single-byte characters. This function is useful only if your database character set contains both single-byte and multibyte characters.
Note:
This function does not support |
The following example illustrates converting from a single byte 'A' to a multi byte 'A' in UTF8:
SELECT dump(TO_MULTI_BYTE( 'A')) FROM DUAL; DUMP(TO_MULTI_BYTE('A')) ------------------------ Typ=1 Len=3: 239,188,161
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|