求解。。MYSQL乱码,已百度还是无法解决
用UTF-8的
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
都用了,控制台System.out.print出来也没错,
但一写进MYSQL就都是问号,
,可视化插件创建数据库时选择了UTF-8的,
用show VARIABLES like 'character_%';,查看
+--------------------------+-------------------------------------------+
| Variable_name | Value |
+--------------------------+-------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | E:\MySQL\MySQL Server 5.5\share\charsets\ |
+--------------------------+-------------------------------------------+
在my.ini那修改
[client]
default-character-set = utf8
[mysqld]
default-character-set = utf8
一改就启动不了,求解救啊!!!!!
mysql
java?jsp
------解决方案--------------------重新安装 数据库吧 我就知道这么多了