Emoticons in TinyMCE [SOLVED]

[MarkE]

I have enabled the emoticons plugin for TinyMCE. It appears to work when editing the page but, after saving, the emoticon just appears as ????

Any suggestions?

[wbmnfktr]

Is your database set to utf8mb4?

// site/config.php
$config->dbCharset = 'utf8mb4';

If not... saving emojis and emoticons won't work as expected.

Not sure about the steps to convert a db to accept it. Sorry.

[MarkE]

22 hours ago, wbmnfktr said:

Not sure about the steps to convert a db to accept it

ALTER DATABASE databasename CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE tablename CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Just need to change the field tables which need to hold emoticons