Home > Database > Mysql Tutorial > mysql5.5乱码解决方案_MySQL

mysql5.5乱码解决方案_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-01 13:35:00
Original
1154 people have browsed it

bitsCN.com 1、先卸载mysql5.5,将所有mysql的文件夹都删除包括注册表里的    1、HKEY_LOCAL_MACHINE/SYSTEM/ControlSet001/Services/Eventlog/Application/MySQL 目录删除
    2、HKEY_LOCAL_MACHINE/SYSTEM/ControlSet002/Services/Eventlog/Application/MySQL 目录删除
  3、HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Eventlog/Application/MySQL 目录删除2、重新安装mysql5.5,注意选择字符集时要选utf83、修改my.ini文件夹里的    [mysql]    default-character-set=gbk4、重启服务,然后在mysql client执行下列命令查看,如果有这样的结果就OK
mysql> show variables like 'chara%';
+--------------------------+----------------------------------------------------
-----+
| 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
     |
| character_sets_dir       | c:/Program Files/MySQL/MySQL Server 5.0/share/chars
ets/ |
+--------------------------+----------------------------------------------------
-----+
8 rows in set (0.00 sec)
   查看表的编码  >show create table person; 5、在jsp页面要如下配置        6

Related labels:
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template