The UNISTR function allows the use of Unicode characters that cannot be represented in the CHAR character set used by the
SQL statement. For example, in an English environment, the UNISTR function could be used to include Chinese characters.
The UNISTR function offers similar functionality to the N'' constant, however the UNISTR function allows Unicode characters
and characters from the CHAR character set, whereas the N'' constant only allows characters from the CHAR character set.
The string-expression contains characters and Unicode escape sequences. The Unicode escape sequences are of the form \uXXXX or \uXXXXXX, where
each X is a hexadecimal digit. The UNISTR function converts each character and each Unicode escape sequence to the corresponding
If a 6-digit Unicode escape sequence is used, its value must not exceed 10FFFF, the largest Unicode code point. A sequence
such as \u234567 is not a 6-digit Unicode escape sequence. It is the 4-digit sequence \u2345 followed by the characters 6
If two adjacent Unicode escape sequences form a UTF-16 surrogate pair, they are combined into one Unicode character in the