Categories:

String & Binary Functions (General)

CHR , CHAR

Converts a Unicode code point (including 7-bit ASCII) into the character that matches the input Unicode. If an invalid code point is specified, an error is returned.

CHAR is an alias for CHR.

See also:

ASCII , UNICODE

Syntax

CHR( <input> )

Arguments

input

The Unicode code point for which the character is returned.

Returns

The data type of the returned value is VARCHAR.

Examples

This example demonstrates the function behavior for some valid Unicode code points:

SELECT column1, CHR(column1)
FROM (VALUES(83), (33), (169), (8364), (0), (null));

This shows the output for the preceding query:

+---------+--------------+
| COLUMN1 | CHR(COLUMN1) |
|---------+--------------|
|      83 | S            |
|      33 | !            |
|     169 | ©            |
|    8364 | €            |
|       0 |              |
|    NULL | NULL         |
+---------+--------------+

This example demonstrates the function behavior for an invalid Unicode code point:

SELECT column1, CHR(column1)
FROM (VALUES(-1));

This shows the output for the preceding query:

FAILURE: Invalid character code -1 in the CHR input

This example demonstrates the function behavior for another invalid Unicode code point:

SELECT column1, CHR(column1)
FROM (VALUES(999999999999));

This shows the output for the preceding query:

FAILURE: Invalid character code 999999999999 in the CHR input