CHR

Syntax

CHR(N)

Description

CHR() interprets each argument N as an integer and returns a VARCHAR(1) string consisting of the character given by the code values of the integer. The character set and collation of the string are set according to the values of the character_set_database and collation_database system variables.

CHR() is similar to the CHAR() function, but only accepts a single argument.

CHR() is available in all sql_modes.

Examples

SELECT CHR(67); +---------+ | CHR(67) | +---------+ | C | +---------+  SELECT CHR('67'); +-----------+ | CHR('67') | +-----------+ | C | +-----------+  SELECT CHR('C'); +----------+ | CHR('C') | +----------+ | | +----------+ 1 row in set, 1 warning (0.000 sec)  SHOW WARNINGS; +---------+------+----------------------------------------+ | Level | Code | Message | +---------+------+----------------------------------------+ | Warning | 1292 | Truncated incorrect INTEGER value: 'C' | +---------+------+----------------------------------------+

See Also

• Character Sets and Collations

• ASCII() - Return ASCII value of first character

• ORD() - Return value for character in single or multi-byte character sets

• CHAR() - Similar function which accepts multiple integers

_{This page is licensed: CC BY-SA / Gnu FDL}