Better Magento 2 WYSIWYG TinyMCE4 & TinyMCE5 Editor by Magefan

Overview

This extension allows you to extend TinyMCE 4 & 5 tools in Magento 2, e.g.: add text color, image, html code, undo-redo, styleselect, fontsizeselect, forecolor backcolor, bold, italic, underline, strikethrough, alignleft, aligncenter, alignright alignjustify, bullist, numlist, outdent, indent, table, image, code. Read more details...

Based on stackexchange answer by Mike Dubs.

Installation

composer require magefan/module-wysiwyg-advanced
php bin/magento setup:upgrade
php bin/magento setup:di:compile
php bin/magento setup:static-content:deploy -f

Enabling emoji 😋

Change "utf8" to "utf8mb4" for initStatements in app/etc/env.php file. Example:

'db' => [
        'table_prefix' => '',
        'connection' => [
            'default' => [
...
                'initStatements' => 'SET NAMES utf8mb4;',
...
            ]
        ]
    ],

Alter database tables and set utf8mb4 encoding. Run SQL queries:

# For blog posts
ALTER TABLE magefan_blog_post CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
# For blog categories
ALTER TABLE magefan_blog_category CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
# For blog tags
ALTER TABLE magefan_blog_tag CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
# For products
ALTER TABLE catalog_product_entity_varchar CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE catalog_product_entity_text CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
# For categories
ALTER TABLE catalog_category_entity_varchar CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE catalog_category_entity_text CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;