MySQL doesn't support some types of characters (such as emojis) with the utf8 encoding. You need to be on MySQL 5.5+ and force utf8mb4 (everywhere, client and server). You can do this sending the query "SET NAMES utf8mb4". Check this

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • Adding data to MySQL database
    via Stack Overflow by James Angelo
  • error adding path to player
    via GitHub by jluc2808
  • 一部の絵文字を使えない
    via GitHub by orekyuu
  • Migration From 6.2 GA2 7.0 GA2 - Forums | Liferay
    via by Unknown author,
    • java.sql.SQLException: Field 'tblid' doesn't have a default value at com.mysql.jdbc.SQLError.createSQLException( at com.mysql.jdbc.MysqlIO.checkErrorPacket( at com.mysql.jdbc.MysqlIO.checkErrorPacket( at com.mysql.jdbc.MysqlIO.sendCommand( at com.mysql.jdbc.MysqlIO.sqlQueryDirect( at com.mysql.jdbc.ConnectionImpl.execSQL( at com.mysql.jdbc.PreparedStatement.executeInternal( at com.mysql.jdbc.PreparedStatement.executeUpdateInternal( at com.mysql.jdbc.PreparedStatement.executeUpdateInternal( at com.mysql.jdbc.PreparedStatement.executeLargeUpdate( at com.mysql.jdbc.PreparedStatement.executeUpdate( at systemnew.UpdateDatabase.add(

    Users with the same issue

    4 times, last one,
    1 times, last one,
    Unknown visitor1 times, last one,
    1 times, last one,
    1 times, last one,
    149 more bugmates