NCHAR (Azure Stream Analytics)

Returns the Unicode character with the specified integer code, as defined by the Unicode standard.

Syntax

NCHAR ( integer_expression )

Arguments

integer_expression

Positive integer from 0 through 1114111 (0 through 0x10FFFF). If a value outside this range is specified, NULL is returned.

Return Types

nvarchar(max)

Examples


SELECT
  NCHAR(33590) AS UnicodeTea_Decimal,
  NCHAR(UNICODE('茶')) AS UnicodeTea_Char
FROM Input

Returns:

UnicodeTea_Decimal UnicodeTea_Char