设置mysql客户端显示为utf8 字符集 （需要保证mysql varchar字段都为utf8）

引用

set character_set_client = utf8;
set character_set_connection = utf8;
set character_set_results = utf8;

评论

2 楼 dengyin2000 2012-05-15  

dev.eye 写道

my.cnf/my.ini

[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
default-character-set=utf8

SHOW VARIABLES LIKE 'character%';
SHOW VARIABLES LIKE 'collation_%';



BTW:US OR GZ now?

what? GZ

1 楼 dev.eye 2012-05-15  

my.cnf/my.ini

[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
default-character-set=utf8

SHOW VARIABLES LIKE 'character%';
SHOW VARIABLES LIKE 'collation_%';



BTW:US OR GZ now?