【保証成功】的 mysql 中文亂碼解決方案

利用status 指令便可以看出現在所有的編碼狀況
<br />mysql> status<br />--------------<br />mysql Ver 14.12 Distrib 5.0.67, for debian-linux-gnu (i486) using readline 5.2<br /><br />Connection id: 30<br />Current database: database_name<br />Current user: root@localhost<br />SSL: Not in use<br />Current pager: stdout<br />Using outfile: ''<br />Using delimiter: ;<br />Server version: 5.0.67-0ubuntu6-log (Ubuntu)<br />Protocol version: 10<br />Connection: Localhost via UNIX socket<br />Server characterset: latin1<br />Db characterset: utf8<br />Client characterset: utf8<br />Conn. characterset: utf8<br />UNIX socket: /var/run/mysqld/mysqld.sock<br />Uptime: 1 hour 33 min 8 sec<br /><br />Threads: 2 Questions: 103 Slow queries: 0 Opens: 398 Flush tables: 1 Open tables: 64 Queries per second avg: 0.018<br />--------------<br />