great龙羽落 great龙羽落
我就是我
关注数: 5 粉丝数: 31 发帖数: 307 关注贴吧数: 9
关于中文乱码问题,求大神帮忙! 一开始mysql默认为Latin字符集,后来我通过my.ini文件改成了 -----+ | character_set_client | gbk | | character_set_connection | gbk | | character_set_database | gbk | | character_set_filesystem | binary | | character_set_results | gbk | | character_set_server | gbk | | character_set_system | utf8 | | character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.5\share\chars ets\ | +--------------------------+---------------------------------------------------- -----+ 但插入中文就报错了而且显示原先插入的中文也为乱码 +------------+-------+-----+---------------------+ | xuehao | name | sex | birthday | +------------+-------+-----+---------------------+ | 2012156001 | ???? | ?? | 1994-10-20 00:00:00 | | 2012156002 | ???? | ?? | 1994-10-25 00:00:00 | | 2012156003 | ???? | ?? | 1994-10-01 00:00:00 | | 2012156004 | ???ù | ?? | 1994-10-02 00:00:00 | | 2012156005 | ???? | ?? | 1994-10-06 00:00:00 | +------------+-------+-----+---------------------+ 5 rows in set (0.06 sec) ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'stude ntinfo' at line 1 利用status查看 mysql Ver 14.14 Distrib 5.5.41, for Win64 (x86) Connection id: 1 Current database: hrbusoft Current user: root@localhost SSL: Not in use Using delimiter: ; Server version: 5.5.41 MySQL Community Server (GPL) Protocol version: 10 Connection: localhost via TCP/IP Server characterset: gbk Db characterset: latin1 Client characterset: gbk Conn. characterset: gbk TCP port: 3306 Uptime: 5 min 44 sec Threads: 1 Questions: 26 Slow queries: 0 Opens: 36 Flush tables: 1 Open tab les: 27 Queries per second avg: 0.075 -------------- 该怎么解决?
1 下一页