Question

只要输入中文就会输出，就无法提交，并且MyEclipse就会出现以下的错误：java.sql.SQLException:

Incorrect string value: '\xE5\x88\xB0\xE8\xBE\xBE' for column 'username' at row 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2409)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2327)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2312)
at org.apache.jsp.addMsg_jsp._jspService(addMsg_jsp.java:77)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

Answer 1

不支持中文。 编码设置额为UTF-8

Answer 2

注意所有的编码格式：utf-8.
如：xml，jsp，尤其是数据库的
报SQL异常，就检查SQL语句，找数据库的问题

Answer 3

额，数据库的编码和myeclipse的编码 改成 UTF-8

Answer 4

页面与后台都同一下编码 一般用utf -8

Answer 5

转码