"Mysql" Storage emoji table intelligence error (Incorrect string value: ' \xf0\x9f\x98\x82\xf0\x9f ... ') solution

• Ordinary string or expression is a placeholder 3 bytes, so utf8 enough, but the mobile side of the emoji placeholder is 4 bytes, the ordinary utf8 is not enough, in order to deal with the wireless internet opportunities and challenges, to avoid the problem of emoji emoticons, involving wireless-related MySQL Database recommendations are in advance using the UTF8MB4 character set, which must be a key element in the mobile Internet industry's technology selection
• MySQL version limit, MySQL 5.5.3 version, support UTF8 for 3 bytes, MySQL 5.5.3 after version support UTF8MB4
  
  • Modify the MySQL configuration file, under Windows for My.ini (Linux for my.cnf), modify the same content

  [Client]default-character-set = Utf8mb4[mysql]default-character-set = Utf8mb4[mysqld]character-set-server = Utf8mb4collation-server = Utf8mb4_unicode_ci

  • Change the corresponding field in the database to Utf8mb4_general_ci
  • Modify the URL of the connection database in the project, remove Characterencoding=utf-8, this step must be

"Mysql" Storage emoji table intelligence error (Incorrect string value: ' \xf0\x9f\x98\x82\xf0\x9f ... ') solution