<![CDATA[
<p>
<style type="text/css">
p.p1 {margin: 0.0px 0.0px 0.0px 28.9px; text-indent: -28.9px; font: 12.0px Menlo; color: #942192}
p.p2 {margin: 0.0px 0.0px 0.0px 28.9px; text-indent: -28.9px; font: 12.0px Menlo; color: #942192; min-height: 14.0px}
span.s1 {font-variant-ligatures: no-common-ligatures}
span.s2 {font: 12.0px 'Apple SD Gothic Neo'; font-variant-ligatures: no-common-ligatures}
span.Apple-tab-span {white-space:pre}
</style>
<p class="p1"><span class="s1">MYSQL SELECT </span><span class="s2">조회</span><span class="s1"> </span><span class="s2">시</span><span class="s1">, </span><span class="s2">한글</span><span class="s1"> </span><span class="s2">물음표</span><span class="s1"> </span><span class="s2">한글</span><span class="s1"> </span><span class="s2">깨짐</span><span class="s1"> </span><span class="s2">현상</span></p>
<p class="p2"><span class="s1"></span><br></p>
<p class="p1"><span class="s1">mysql> status</span></p>
<p class="p1"><span class="s1">--------------</span></p>
<p class="p1"><span class="s1">.</span></p>
<p class="p1"><span class="s1">.</span></p>
<p class="p1"><span class="s1">.</span></p>
<p class="p2"><span class="s1"></span><br></p>
<p class="p1"><span class="s1">Server characterset:<span class="Apple-tab-span"> </span>utf8mb4</span></p>
<p class="p1"><span class="s1">Db <span class="Apple-converted-space"> </span>characterset:<span class="Apple-tab-span"> </span>utf8</span></p>
<p class="p1"><span class="s1">Client characterset:<span class="Apple-tab-span"> </span>latin1</span></p>
<p class="p1"><span class="s1">Conn.<span class="Apple-converted-space"> </span>characterset:<span class="Apple-tab-span"> </span>latin1</span></p>
<p class="p1"><span class="s1">.</span></p>
<p class="p1"><span class="s1">.</span></p>
<p class="p1"><span class="s1">.</span></p>
<p class="p1"><span class="s1">.</span></p>
<p class="p2"><span class="s1"></span><br></p>
<p class="p2"><span class="s1"></span><br></p>
<p class="p1"><span class="s1">SELECT CONVERT(CONVERT(CONVERT(your_column_name USING utf8) USING binary) USING latin1) FROM user_table_name;</span></p><br></p>
<!-- -->
]]>
카페 게시글
RDBMS
MYSQL SELECT 조회 시, 한글 물음표 한글 깨짐 현상
운영자
추천 0
조회 2,760
18.07.15 23:42
댓글 0
다음검색
