SQL NCHAR Function

The NCHAR function returns a Unicode character for a given integer value.

It accepts an integer value from 0 to 65535, or a hex value from 0 through 0xFFFF.

If the value provided exceeds the range, a NULL value is returned.

Example

#

This example returns a Unicode character for the given integer value.

SELECT NCHAR(99) AS 'NCHAR(99)',
       NCHAR(188) AS 'NCHAR(188)',
       NCHAR(248) AS 'NCHAR(248)',
       NCHAR(377) AS 'NCHAR(377)',
       NCHAR(650) AS 'NCHAR(650)'
Result:  1 record
NCHAR(99) NCHAR(188) NCHAR(248) NCHAR(377) NCHAR(650)
c ¼ ø Ź ʊ

Syntax

Syntax of the NCHAR function.

NCHAR(value)

value -- an integer value from 0 to 65355, or hex value 0 through 0xFFFF.


You may also like



Guides


vsn 3.1