CHAR

​

Syntax

​

Scalar

char(value)

​

Arguments

​

Returns

• Type: STRING
• Possible values: A character in Unicode U+0000 through U+00FF; an empty string for negative values.
• NULL behavior: Returns NULL for NULL input.

​

Properties

​

Usage notes

• Nonnegative input is reduced modulo 256. It does not construct arbitrary Unicode code points.
• INTEGER and INT mean the same type; STRING means VARCHAR text. NULL can be used with a supported type. Cast NULL explicitly when its type would otherwise be unclear.

​

Examples

​

Typical behavior

SELECT char(65) AS letter, char(321) AS wrapped, char(-1) AS negative;

​

Build a string from character codes

SELECT concat(char(72), char(105)) AS greeting;