CHR Function
This function accepts an unsigned integer argument, and returns a single logical character.
The CHR function has this syntax:
CHR Function
| Element | Description | Restrictions | Syntax |
|---|---|---|---|
| expression | Expression that evaluates to a nonnegative whole number less than 256 | Must be an integer in the range 0 through 255 (inclusive) |
Expression |
The data type of the return value is VARCHAR(1).
The
argument can be SMALLINT, INTEGER, SERIAL, INT8, SERIAL8, BIGINT,
or BIGSERIAL. The argument must evaluate to a whole number in the
range 0 through 255.
If the
argument is an integer in the range 0 through 127,
the return value is the corresponding single-byte ASCII code point.
For a listing of the characters corresponding to the ASCII code points 0 through 127,
see Collating Order for U.S. English Data.
If
the argument is an integer in the range
128 through 255,
the return value is the corresponding 2-byte code point in the default
code set. - On UNIX™ platforms, the default code set is ISO8859-1.
- On Windows™ platforms, the default code set is Microsoft™ 1252.