{"action":"closed","issue":{"url":"https://api.github.com/repos/craftcms/cms/issues/1627","repository_url":"https://api.github.com/repos/craftcms/cms","labels_url":"https://api.github.com/repos/craftcms/cms/issues/1627/labels{/name}","comments_url":"https://api.github.com/repos/craftcms/cms/issues/1627/comments","events_url":"https://api.github.com/repos/craftcms/cms/issues/1627/events","html_url":"https://github.com/craftcms/cms/issues/1627","id":221359110,"number":1627,"title":"Add support for emoji 🙏","user":{"login":"connor-baer","id":11017722,"avatar_url":"https://avatars3.githubusercontent.com/u/11017722?v=3","gravatar_id":"","url":"https://api.github.com/users/connor-baer","html_url":"https://github.com/connor-baer","followers_url":"https://api.github.com/users/connor-baer/followers","following_url":"https://api.github.com/users/connor-baer/following{/other_user}","gists_url":"https://api.github.com/users/connor-baer/gists{/gist_id}","starred_url":"https://api.github.com/users/connor-baer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/connor-baer/subscriptions","organizations_url":"https://api.github.com/users/connor-baer/orgs","repos_url":"https://api.github.com/users/connor-baer/repos","events_url":"https://api.github.com/users/connor-baer/events{/privacy}","received_events_url":"https://api.github.com/users/connor-baer/received_events","type":"User","site_admin":false},"labels":[{"id":527359859,"url":"https://api.github.com/repos/craftcms/cms/labels/bug","name":"bug","color":"ee0701","default":true}],"state":"closed","locked":false,"assignee":{"login":"brandonkelly","id":47792,"avatar_url":"https://avatars2.githubusercontent.com/u/47792?v=3","gravatar_id":"","url":"https://api.github.com/users/brandonkelly","html_url":"https://github.com/brandonkelly","followers_url":"https://api.github.com/users/brandonkelly/followers","following_url":"https://api.github.com/users/brandonkelly/following{/other_user}","gists_url":"https://api.github.com/users/brandonkelly/gists{/gist_id}","starred_url":"https://api.github.com/users/brandonkelly/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/brandonkelly/subscriptions","organizations_url":"https://api.github.com/users/brandonkelly/orgs","repos_url":"https://api.github.com/users/brandonkelly/repos","events_url":"https://api.github.com/users/brandonkelly/events{/privacy}","received_events_url":"https://api.github.com/users/brandonkelly/received_events","type":"User","site_admin":false},"assignees":[{"login":"brandonkelly","id":47792,"avatar_url":"https://avatars2.githubusercontent.com/u/47792?v=3","gravatar_id":"","url":"https://api.github.com/users/brandonkelly","html_url":"https://github.com/brandonkelly","followers_url":"https://api.github.com/users/brandonkelly/followers","following_url":"https://api.github.com/users/brandonkelly/following{/other_user}","gists_url":"https://api.github.com/users/brandonkelly/gists{/gist_id}","starred_url":"https://api.github.com/users/brandonkelly/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/brandonkelly/subscriptions","organizations_url":"https://api.github.com/users/brandonkelly/orgs","repos_url":"https://api.github.com/users/brandonkelly/repos","events_url":"https://api.github.com/users/brandonkelly/events{/privacy}","received_events_url":"https://api.github.com/users/brandonkelly/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2017-04-12T19:00:56Z","updated_at":"2017-04-12T19:37:38Z","closed_at":"2017-04-12T19:37:38Z","body":"### Description\r\nCraft 3 doesn't seem to support emoji in any field that I tried (plain text, rich text, category). 😿 \r\n\r\nI found [this StackExchange](https://craftcms.stackexchange.com/questions/17277/mysql-collation-utf8mb4-unicode-ci-emojis) answer from @takobell where he states that Craft will automatically HTML encode emoji in a rich text field. This doesn't seem to be the case. His answer also mentions the possibility to set the database charset and collation to `utf8mb4` and `utf8mb4_unicode_ci`. Will this work with Craft 3? Is it advisable to do?\r\n\r\n### Steps to reproduce\r\n\r\n1. 😎 Enter a cool emoji into a field.\r\n2. 💾 Save the entry.\r\n3. ⚠️ Receive an error message like this one:\r\n```\r\nInternal Server Error\r\n\r\nSQLSTATE[HY000]: General error: 1366 Incorrect string value: '\\xF0\\x9F\\x95\\x93' for column 'title' at row 1 The SQL being executed was: UPDATE `craft_content` SET `elementId`=217, `siteId`=1, `title`='New Website 🍻', `field_featured`=1, `field_passphrase`='', `dateUpdated`='2017-04-12 18:36:57' WHERE `id`='348'\r\n```\r\n\r\n### Additional info\r\n\r\n- Craft version: Craft 3.0.0-beta.10 (I also tested with Craft CMS 2.6.2971: slightly different error message, same problem.\r\n- PHP version: 7.1.4\r\n- Database driver & version: MySQL 5.7.17\r\n"}}
{"actor":{"display_login":"brandonkelly"}}