New Expressions And Built-In Functions

New Expressions and Built-in Functions

Adriano dos Santos Fernandes

Returns the Unicode character with the specified code point.

Syntax

UNICODE_CHAR( <number> )

Note	The argument to UNICODE_CHAR must be a valid Unicode code point and not in the range of high/low surrogates (0xD800 to 0xDFFF), otherwise it throws an error.

Example

select unicode_char(x) from y;

Returns the Unicode code point of the first character of the specified string, or zero if the string is empty.

Syntax

UNICODE_VAL( <string> )

Example

select unicode_val(x) from y;