I wanted to add an emoji to a comment I just made on my last post, and I wanted something more than the old-style :) emoticon which I have used for (mumble) years. A quick Google told me about the ckeditor_emoji module for Dupal, with a comment by Jeff Geerling of all people (A YouTuber I occasionally watch, who has contributed many Ansible modules I regularly use), to make sure that your Drupal database supports the "utf8mb4" encoding. It turns out that unlike MySQL, PostgreSQL's UTF-8 encoding does not differentiate between the utf8mb3 and utf8mb4 encodings, so no need to dump the database, drop the old one, recreate it with the new encoding, and restore. PostgreSQL scores another point in its favor in my book, in spite of its lack of GROUP_CONCAT() and a few other features. Maybe someday, I will even look into writing an extension for PostgreSQL to provide that functionality. I have read it is possible, I just have never looked into it, either to seeing if one already exists, or rolling my own. But now, I can haz full-blown emoji's.
Oh... and a bit of history. About 15 years ago, while working at Carnegie Mellon, I remember meeting Scott Fahlman, who invented the first recognizable emoticon, :-), when he was presented with the first Smiley Award in 2008.
Categories