CHR
Converts the first character of an INTEGER datatype to a VARCHAR.
Behavior Type
Syntax
CHR ( expression )
Parameters
expression |
(INTEGER) is the string to convert and is masked to a single character. |
Notes
- CHR is the opposite of the ASCII function.
- CHR operates on UTF-8 characters, not only on single-byte ASCII characters. It continues to get the same results for the ASCII subset of UTF-8.
Examples
This example returns the VARCHAR datatype of the CHR expressions 65 and 97 from the employee table:
=> SELECT CHR(65), CHR(97) FROM employee; CHR | CHR -----+----- A | a A | a A | a A | a A | a A | a A | a A | a A | a A | a A | a A | a (12 rows)