用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
一改就启动不了,求解救啊!!!!!mysqljava jsp
<%@ 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
一改就启动不了,求解救啊!!!!!mysqljava jsp
像这样jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=utf8
然后在服务里重启mysql服务,
其他的都不好使
把字符串转成GBK,在写入数据库,应该就没问号了。
这个没办法的
你可以借助于工具 navat什么的 看到的就不是乱码了
改了[mysqld],就启动不了
吗?
试了,还是不行
你的mysql是不是有问题啊我刚刚试了我的my.ini改了完全没有问题[mysql]
default-character-set=utf8[mysqld]
default-character-set=utf8
conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/jsd1210db?" +
"useUnicode=true&characterEncoding=utf8",
"root","mysql");
设置编码了?
还不行等下就只有重装mysql试试了
不懂这个的配置