TO_MULTI_BYTE

Syntax

TO_MULTI_BYTE
(
  str  IN text
)
RETURNS text;

Overview

The TO_MULTI_BYTE function converts a single-byte (ASCII) character to the corresponding multi-byte character in the database encoding.

For example, characters in the ASCII range (0x20~ 0x7E) are converted according to a predefined multi- byte mapping table (UTF8, EUC_JP, EUC_CN, etc.).

If the database encoding corresponds to one of its mapping tables, it replaces each character in the input string with the corresponding multi-byte string, otherwise it returns the characters as they are.

Parameter

Parameter	Description
str	text type; String to convert. ASCII characters are replaced with multibyte characters.

Example

SELECT oracle.TO_MULTI_BYTE('Hello, World!');

       to_multi_byte        
----------------------------
 Ｈｅｌｌｏ，　Ｗｏｒｌｄ！
(1 row)