Upgrade test on unsupported MySQL version Before upgrading to this patch set up a Moodle site on a version of MySQL that doesn't have full Unicode support (i.e. having the collation set to " utf8_unicode_ci " instead of " utf8mb4_unicode_ci ") Apply this patch and upgrade Moodle Log in as admin Go to the advanced features settings in the site administration CONFIRM that you can't enable the emoji picker setting. Instead you should have message that directs you to upgrade your database. Open the messaging drawer and view a conversation (self conversation is fine) CONFIRM that there is no emoji picker available in the conversation footer Test admin setting Upgrade your MySQL database according to the instructions in the admin setting (or just install a new site on a supported version of the database) Log in as admin Go to the advanced features settings in the site administration CONFIRM that you see an enable/disable checkbox for showing the emoji picker CONFIRM that if you enable the picker when you view a conversation you see the emoji picker in the footer of the conversation area CONFIRM that if you disable the picker when you view a conversation you do not see the emoji picker in the footer of the conversation area Emoji picker (Please test on each of the different supported browsers) General testing Open the emoji picker by clicking on the smiley face next to the message box CONFIRM that you can navigate to different categories using the category selectors at the top of the picker CONFIRM that you can scroll through the list of emojis CONFIRM that clicking an emoji inserts it at the cursor position in the text area and closes the picker CONFIRM that clicking anywhere outside of the picker closes it (if it's open) CONFIRM that hovering over an emoji shows a preview and the short name in the footer CONFRIM that if you tab into an emoji and give it focus that it shows the preview CONFIRM that hitting the escape key closes the picker, if the focus is in the picker Recent emojis Note: the recent emojis don't work if you have cachejs enabled in Moodle (nothing saves to local storage if that is enabled) CONFIRM that each time you select an emoji in the picker it is added to the list of emojis in the "Recent" category (first category) CONFIRM that it only remembers up to 21 emojis (3 rows) CONFIRM that clicking on an emoji in the recent list moves that emoji to the start of the list Search emojis Search for an emoji using it's short name CONFIRM that the search matches all parts of the short name, e.g. searching for "ile" should show results for "smile" CONFIRM that clearing the search term hides the results CONFIRM that clicking on an emoji in the search results adds it to the message text and to the list of recent emojis Emoji auto complete (Please test on each of the different supported browsers) Begin typing a message in the text area Trigger the auto complete menu by typing the colon ( : ) character CONFIRM that a single colon character will open the auto complete and show you the list of recent emojis Start typing to search for an emoji, e.g. :smi CONFIRM that the suggestion list is updated with new matches CONFIRM that you can use the left/right arrow keys to navigate through the list of suggestions CONFIRM that you can hit the escape key to close the list of suggestions CONFIRM that you can continue typing to open the suggestion again, e.g. press the l key so that you've got :smil CONFIRM that you can press the enter key to select one of the suggested emojis and it replaces the word you were typing in the text area Continue typing Type a full short name, e.g. :smile: CONFIRM that once you've added the second colon character it auto completes the short name into the actual emoji