oschina mysql_关于mysql字符集，OSchina是怎么做到的?

落地花开啦

oschina 整个应用都是用 UTF-8 编码，因此一般不会有这个问题

表结构是这样的

CREATE TABLEtest` (

value varchar(500) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=utf8;`

下面是测试的main方法

public static void main(String[] args) throws SQLException, InstantiationException, IllegalAccessException, ClassNotFoundException {

String driverName = "com.mysql.jdbc.Driver";

Class.forName(driverName).newInstance();

Connection con1 = DriverManager.getConnection("jdbc:mysql://192.168.1.33:3306/test?characterEncoding=UTF8", "test", "111111");

PreparedStatement ps = con1.prepareStatement("insert into test(`value`) values(?)");

// ps.setString(1, "“𢜶”fff");

ps.executeUpdate();

ps.close();

con1.close();

}

出现异常

`

Exception in thread "main" java.sql.SQLException: Incorrect string value: 'xF0xA2x9CxB6xE2x80...' for column 'value' at row 1

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)

at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1129)

at

`

0人评论

发布于2016-04-05 15:28:21

取消

评论