Illegal mix of collations (utf8_general_ci,IMPLICIT), (gb2312_chinese_ci,COERCIBLE) for operation 'between'
linux下面用MYSQL出现这样的问题,我好像SQL用的默认字符集是GB2312,连接池的和网页的charset都是GB2312,为什么会出现这样的情况呢?
javax.servlet.ServletException: General error message from server: "Illegal mix of collations (utf8_general_ci,IMPLICIT), (gb2312_chinese_ci,COERCIBLE), (gb2312_chinese_ci,COERCIBLE) for operation 'between'"
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.personnel.report.totalreport2_jsp._jspService(totalreport2_jsp.java:212)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)