专家经验总结,和大家分享:* 设置 MySQL 的 my.cnf 文件,在 [client]/[mysqld]部分都设置默认的字符集:
CODE:[Copy to clipboard][client]
default-character-set = utf8
[mysqld]
default-character-set = utf8
该设置需要重新启动 MySQL 服务器。启动之后在 mysql 命令行下可以用 'status' 命令查看:
CODE:
mysql> status
--------------
mysql Ver 14.12 Distrib 5.0.26, for -netbsdelf (i386) using EditLine wrapperConnection id: 16
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.0.26-log
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /tmp/mysql.sock
Uptime: 1 hour 7 min 49 sec
*在创建表的时候,加上 default character='utf8' 这样的语句:CODE:CHARSET='utf8'
* 在执行 MYSQL 语句时先执行 'SET NAMES 'utf8'' 语句:
CODE:SET NAMES 'utf8'
这样基本就能搞定中文问题了。转http://bbs.chinaunix.net/viewthread.php?tid=905650
CODE:[Copy to clipboard][client]
default-character-set = utf8
[mysqld]
default-character-set = utf8
该设置需要重新启动 MySQL 服务器。启动之后在 mysql 命令行下可以用 'status' 命令查看:
CODE:
mysql> status
--------------
mysql Ver 14.12 Distrib 5.0.26, for -netbsdelf (i386) using EditLine wrapperConnection id: 16
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.0.26-log
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /tmp/mysql.sock
Uptime: 1 hour 7 min 49 sec
*在创建表的时候,加上 default character='utf8' 这样的语句:CODE:CHARSET='utf8'
* 在执行 MYSQL 语句时先执行 'SET NAMES 'utf8'' 语句:
CODE:SET NAMES 'utf8'
这样基本就能搞定中文问题了。转http://bbs.chinaunix.net/viewthread.php?tid=905650
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货