작성
·
153
답변 2
1
저도 궁금해서 찾아봤는데, 문자열을 강제로 캐스팅해주니 정상적으로 출력이 되었습니다!
SELECT CONCAT( cast(char(97, 100, 109, 105, 110) as char));
/*
+-----------------------------------------------------+
| CONCAT(cast(char(97, 100, 109, 105, 110) as char)) |
+-----------------------------------------------------+
| admin |
+-----------------------------------------------------+
*/
SELECT cast(char(97) as char);
/*
+------------------------+
| cast(char(97) as char) |
+------------------------+
| a |
+------------------------+
*/
1