Text after smiley disappeared when posting

Once the change is made to inc\classes\ChWsbDb.php it's a simple matter of changing the database default char set and collation to utf8mb4_unicode_ci on any table that stores the posts coming from tinymce.

I just need to find them all. 😱

Yes.  I notice the issue appears when you are commenting in blog posts, videos, etc; basically the comment system which is shared, when you turn on the tinyMCE editor in comments.

Ok. Eventually i am going to have to go through all of Cheetah and update everything to full UTF8 4 character multibyte support as many things such as the new tinymce is using it.

Right now Cheetah is using utf8_general_ci which does not support all the expansions. Also defaults to standard UTF8 in MYSQL which is a alias for utf8mb3 which only supports up to 3 bytes per utf8 character.

So to fix the fourms you can do the following right now.

Edit inc\classes\ChWsbDb.php

Look for this at line  100

"mysql:{$sSocketOrHost};dbname={$this->dbname};charset=utf8",

Change to this.

"mysql:{$sSocketOrHost};dbname={$this->dbname};charset=utf8mb4",

Next run the following 3 querys in phpmyadmin

ALTER TABLE `ch_forum_post` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

ALTER TABLE `ch_forum_post` CHANGE `user` `user` VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0';

ALTER TABLE `ch_forum_post` CHANGE `post_text` `post_text` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;

Yes, I have seen similar unicode replacing icons when accessing a https site with http when it doesn't have the server redirect in place.

Ok. I'll look into it.

Update: Appears to have something to do with unicode.

Update: I tested my Cheetah beta site and the text gets posted but the smileys are replaced with four question marks; ????

This may be something to do with the new tinyMCE; the current site has the 5.7 tinyMCE and there is no problem posting. 

Deano, I haven't fully tested to see what is happening here.  I twice try to post what is show in the screen shot and it doesn't post after after the first smiley; or the smiley itself.  https://www.cheetahwsb.com/forum/topic/Cheetah-1-2-0-Final-has-been-released-.htm  I reporting this as a bug of the site since I have not tested on another Cheetah site and it happened twice with me here.  When I get time, I will see how the current Cheetah site (not sure if that site uses the forum) operates.  I was planning on running the update today but will first see about the forum posting.