mysql 关于dao.insert报错问题，而sql语句能正常执行

如题，sql是这样的：
INSERT INTO dct_user(nickname,create_time)
VALUES('??????_?????','2016-09-03 17:22:22')

wendal

1楼•3032天前

是不是应该贴一下报错内容呢？

来自炫酷的 NutzCN

yong9664

2楼•3032天前

@wendal

java.sql.SQLException: Incorrect string value: '\xF0\x9F\xA6\x81\xE2\x86...' for column 'nickname' at row 1
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2822)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1536)
	at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1159)
	at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:684)
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:768)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runPreparedStatement(NutDaoExecutor.java:268)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:82)
	at org.nutz.dao.impl.DaoSupport$DaoExec.invoke(DaoSupport.java:316)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:59)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:239)
	…………

wendal

3楼•3032天前

@yong9664 谷歌搜utf8mb4

来自炫酷的 NutzCN

请先登陆