답변 1개
리자
Expert
11년 전
아래와 같이 mysql 을 쉘로 접속하신후 DB, Client 의 charset 이 utf8 로 설정되어 있는지 확인하여 주십시오.
</div>
<div>$ mysql -u유저명 -p패스워드 디비명</div>
<div>Welcome to the MySQL monitor. Commands end with ; or \g.</div>
<div>Your MySQL connection id is 2127</div>
<div>Server version: 5.1.30-log Source distribution</div>
<div>
</div>
<div>Type 'help;' or '\h' for help. Type '\c' to clear the buffer.</div>
<div>
</div>
<div>mysql> \s</div>
<div>--------------</div>
<div>mysql Ver 14.14 Distrib 5.1.30, for pc-linux-gnu (i686) using readline 5.1</div>
<div>
</div>
<div>Connection id:<span class="Apple-tab-span" style="white-space: pre"> </span>2127</div>
<div>Current database:<span class="Apple-tab-span" style="white-space: pre"> </span>sir</div>
<div>Current user:<span class="Apple-tab-span" style="white-space: pre"> </span>sir@localhost</div>
<div>SSL:<span class="Apple-tab-span" style="white-space: pre"> </span>Not in use</div>
<div>Current pager:<span class="Apple-tab-span" style="white-space: pre"> </span>stdout</div>
<div>Using outfile:<span class="Apple-tab-span" style="white-space: pre"> </span>''</div>
<div>Using delimiter:<span class="Apple-tab-span" style="white-space: pre"> </span>;</div>
<div>Server version:<span class="Apple-tab-span" style="white-space: pre"> </span>5.1.30-log Source distribution</div>
<div>Protocol version:<span class="Apple-tab-span" style="white-space: pre"> </span>10</div>
<div>Connection:<span class="Apple-tab-span" style="white-space: pre"> </span>Localhost via UNIX socket</div>
<div>Server characterset:<span class="Apple-tab-span" style="white-space: pre"> </span>utf8</div>
<div><b>Db characterset:<span class="Apple-tab-span" style="white-space: pre"> </span>utf8</b></div>
<div><b>Client characterset:<span class="Apple-tab-span" style="white-space: pre"> </span>utf8</b></div>
<div>Conn. characterset:<span class="Apple-tab-span" style="white-space: pre"> </span>utf8</div>
<div>UNIX socket:<span class="Apple-tab-span" style="white-space: pre"> </span>/tmp/mysql.sock</div>
<div>Uptime:<span class="Apple-tab-span" style="white-space: pre"> </span>2 days 8 hours 38 min 55 sec</div>
<div>
</div>
<div>Threads: 1 Questions: 22833 Slow queries: 3 Opens: 8731 Flush tables: 1 Open tables: 256 Queries per second avg: 0.111</div>
<div>--------------</div>
<div>
로그인 후 평가할 수 있습니다
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인