mysql设置中文




?发短消息
?所属博客
mysql>?select?*?from?employee;
+-------------+-----------+------------+------------+------+--------------+
|?employee_id?|?last_name?|?first_name?|?birth??????|?sex??|?emmail???????|
+-------------+-----------+------------+------------+------+--------------+
|??????????12?|???????????|????????????|?1978-12-11?|?f????|?aaa@asdf.com?|
|??????????13?|???????????|????????????|?1978-12-11?|?f????|?aaa@asdf.com?|
|??????????14?|???????????|????????????|?1978-12-11?|?f????|?aaa@asdf.com?|
|??????????15?|???????????|????????????|?1978-12-11?|?f????|?aaa@asdf.com?|
|??????????16?|???????????|????????????|?1978-12-11?|?f????|?aaa@asdf.com?|
|??????????17?|???????????|????????????|?1978-12-11?|?f????|?aaa@asdf.com?|
+-------------+-----------+------------+------------+------+--------------+
这当然不是我们希望看到的,我们需要的现实完美正确的中文:
我们还有最后一招:
mysql>?SET?NAMES?'gbk'?;
Query?OK,?0?rows?affected?(0.00?sec)