UNICODE_CHAR()

Character from Unicode code point

Result type

CHAR(1) CHARACTER SET UTF8

Syntax

UNICODE_CHAR (code)

Table 1. `UNICODE_CHAR` Function Parameter
Parameter	Description
code	The Unicode code point (range 0…0x10FFFF)

Returns the character corresponding to the Unicode code point passed in the argument.

Unicode code point from string

Result type

INTEGER

Syntax

UNICODE_VAL (ch)

Table 1. `UNICODE_VAL` Function Parameter
Parameter	Description
ch	A string of the `[VAR]CHAR` data type or a text `BLOB`

Returns the Unicode code point (range 0…0x10FFFF) of the character passed in.

If the argument is a string with more than one character, the Unicode code point of the first character is returned.
If the argument is an empty string, 0 is returned.
If the argument is NULL, NULL is returned.