mysql存入中文乱码问题

1. 查询编码

SHOW VARIABLES LIKE 'character_set_%'

2. 改数据库和单项

alter database tsdr character set utf8;
set character_set_database=utf8;
set character_set_server=utf8;

此招好使！！！

3. vi /etc/my.cnf ，[mysqld]下的 port的下一行写入character-set-server=utf8  也可以设置成其他类型的字符编码，把utf8换成gbk等

重启服务器  service mysqld restart

 

jsp 设置

 $.getJSON("/portal/edu/updateEdu?id="+id+"&item="+element.id+"&value="+encodeURI(element.value,"utf-8"),function(data){
}）；

 后台java设置：

@RequestMapping("/updateEdu")
	public String updateEdu(Long id,String item,String value,HttpServletResponse response){
		//String result = "{\"result\":\"success\"}";
		try {
			URLDecoder.decode(value,"utf-8");
		} catch (Exception e) {
			e.printStackTrace();
		}
		
		
		eduService.updateById(id,item,value);
		
		JSONObject data = new JSONObject();
		try {
			data.put("result", "success");
		} catch (Exception e) {
			System.out.println(e.getMessage());
		}
		
		
		PrintWriter out = null;
		response.setCharacterEncoding("UTF-8");
		response.setContentType("text/html; charset=UTF-8"); 
	    try {
	    	out=response.getWriter();
	        out.write(data.toString());
	        out.flush();
			out.close();	
			return null;
	    } catch (IOException e) {
	        e.printStackTrace();
	    }	   
		return "redirect:/edu/getAllEdu";
	}