DROP TABLE IF EXISTS `t1`;
CREATE TABLE `t1` (`a` text);
INSERT INTO `t1` (`a`) VALUES (UNHEX('58C2A059')); -- X&nbsp;Y
SELECT HEX(`a`) FROM `t1`;
SELECT `a` FROM `t1`;
SELECT HEX(JSON_ARRAY(`a`)) FROM `t1`;
SELECT JSON_ARRAY(`a`) FROM `t1`;
SELECT HEX(JSON_ARRAYAGG(`a`)) FROM `t1`;
SELECT JSON_ARRAYAGG(`a`) FROM `t1`;
