apache配置,使用mysql数据库,需要保存中文,在insert语句中使用中文,能够正常显示,但是使用select语句查询时,中文不显示。
查mysql的status如下:
Connection id: 71483
Current database: game
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 4.1.11-standard-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: 54 days 16 hours 33 min 9 sec
查mysql的status如下:
Connection id: 71483
Current database: game
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 4.1.11-standard-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: 54 days 16 hours 33 min 9 sec
http://topic.csdn.net/u/20071124/08/3b7eae69-ed1d-4a77-8895-9930bf3601af.html
不行的话:
2.看数据库和表的默认字符集
show create table t;
可以改为gbk,gbk2312,utf8:
alter table t2 convert to character set utf8;
再select试试。
插入数据如:insert into bsn_game_type value(1,'榜单');
插入实现正常,但是select * from bsn_game_type;第一列显示1,第二列显示空白。