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
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.