在进行了以下操作之后,乱码依旧存在,真心求解,谢谢。
一、show variables like 'character%';
显示:
| Variable_name | Value
|
+--------------------------+----------------------------------------------------
-----+
| character_set_client | gbk
|
| character_set_connection | gbk
|
| character_set_database | utf8
|
| character_set_filesystem | binary
|
| character_set_results | gbk
|
| character_set_server | utf8
|
| character_set_system | utf8
所以,我进行了下一步操作:set names utf8;
显示:
character_set_client | utf8
|
| character_set_connection | utf8
|
| character_set_database | utf8
|
| character_set_filesystem | binary
|
| character_set_results | utf8
|
| character_set_server | utf8
|
| character_set_system | utf8
二、对已存在的数据库db_test进行修改:
alter database db_test default character set utf8 collate utf8_general_ci;
三、对db_test里的所有表分别进行修改:
alter table tb_test1 default character set utf8 collate utf8_general_ci;
………………
…………
四、对my.ini文件进行修改:
先停止MySQL服务,再进行如下修改:
[mysql]
default-character-set=utf8
[mysqld]
# The default character set that will be used when a new schema or table is
# created and no character set is defined
character-set-server=utf8
五、对所有的JSP页面文件进行修改:
为什么还会乱码?!服务器端及浏览器端。
2012年8月09日 11:38