如何使用Java代码通过JSON请求在MySQL中保存印地语字符

Question

@RequestMapping(value = "/MultiLingual", method = RequestMethod.GET,consumes={"application/json; charset=UTF-8"})
@ResponseBody public String hi(@RequestParam("name") String name ,HttpServletResponse httpServletResponse) throws IOException {
    httpServletResponse.setCharacterEncoding("UTF-8");
    System.out.println(name +"(((((((( अलविदा");
    int update  = jdbcTemplate.update("INSERT INTO multi_lingual(Name) values(?)",name);
    String nameAlvida = jdbcTemplate.queryForObject("Select name from multi_lingual order by ID DESC limit 0,1", String.class);
    System.out.println(update+" ::: update"); 
    if(update>0)
    {
        System.out.println("inserted");
    }
     System.out.println(" "+StringEscapeUtils.unescapeJava(name));
    return "success = "    +nameAlvida;
}

Answer 1

您只需要进行一些更改。

#update Table properties
ALTER TABLE table_name CHANGE column_name column_name VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
#update database properties
datasource.url = jdbc:mysql://localhost:3306/DBName?useUnicode=yes&characterEncoding=UTF-8