How to build a string from byte values using the CHAR() function?

CHAR(N, ... USING charset_name) is a MySQL built-in function that builds a string from multiple integers interpreted as ASCII byte values. For example:

SELECT CHAR(70, 89, 73), ASCII('F'), ASCII('Y'), ASCII('I');
  -- +------------------+------------+------------+------------+
  -- | CHAR(70, 89, 73) | ASCII('F') | ASCII('Y') | ASCII('I') |
  -- +------------------+------------+------------+------------+
  -- | FYI              |         70 |         89 |         73 |
  -- +------------------+------------+------------+------------+

Reference information of the CHAR() function:

CHAR(N, ... USING charset_name): str
  Interprets each argument N as an integer and returns a string consisting
  of the characters given by the code values of those integers. NULL
  values are skipped.

  CHAR() arguments larger than 255 are converted into multiple result
  bytes. For example, CHAR(256) is equivalent to CHAR(1,0), and
  CHAR(256*256) is equivalent to CHAR(1,0,0).

Arguments, return value and availability:
  N, ...: One or more integers to be interpreted.
  USING charset_name: Optional. Default is USING ascii.
  str: Return value. The string created from given byte values.
  Available since MySQL 4.0.

Related MySQL functions:

• ASCII() - ASCII Value of First Character

⇒ CHAR_LENGTH() - Number of Characters

⇐ BIT_LENGTH() - Number of Bits in String

⇑ MySQL Functions on Character String Values

⇑⇑ MySQL Function References