yjpark1789

저도 궁금해서 찾아봤는데, 문자열을 강제로 캐스팅해주니 정상적으로 출력이 되었습니다!
<pre class="language-java"><code>SELECT CONCAT( cast(char(97, 100, 109, 105, 110) as char));

/*
+-----------------------------------------------------+
| CONCAT(cast(char(97, 100, 109, 105, 110) as char)) |
+-----------------------------------------------------+
| admin |
+-----------------------------------------------------+
*/</code></pre>

<pre class="language-java"><code>SELECT cast(char(97) as char);

/*
+------------------------+
| cast(char(97) as char) |
+------------------------+
| a |
+------------------------+
*/
</code></pre>

yjpark1789

Posts