还是编码问题!

smr

mysql安装选字符集为gb2312,JSP页面设置为gb2312,jdbc中的URL也设置了useUnicode=true&characterEncoding=gb2312,但就是无法向数据库插入记录!
如果将带中文的sql语句编码改为ISO-8859-1可以插入,但全是"???"的乱码.
而从控制台插入带中文的记录却没有问题,而且可以从JSP页面正确的读出来.

代码

String sq = "insert into operation values('abc','你好',null)";
int flag = 0;
flag = statement.executeUpdate(sq);
if(flag != -1)
out.print("insert is done!<br>";
else
out.print("there is something wrong<br>";


报错如下:

exception

javax.servlet.ServletException: Data too long for column 'operation' at row 1
        org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:846)
        org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
        org.apache.jsp.chinese_jsp._jspService(org.apache.jsp.chinese_jsp:114)
        org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
        org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
        org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


root cause

java.sql.SQLException: Data too long for column 'operation' at row 1
        com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2901)
        com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1584)
        com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1675)
        com.mysql.jdbc.Connection.execSQL(Connection.java:2295)
        com.mysql.jdbc.Connection.execSQL(Connection.java:222
        com.mysql.jdbc.Statement.executeUpdate(Statement.java:1262)
        org.apache.jsp.chinese_jsp._jspService(org.apache.jsp.chinese_jsp:74)
        org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
        org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
        org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

请不吝赐教呀!

xxjoyjn

换个JDBC驱动吧