Emoji
By Julie Kubiak on Wednesday, 01 December 2021
Posted in General Issues
Likes 0
Views 719
Votes 0
Hi,

Some users are able to copy and paste some emojis onto EasySocial statuses, the rest of the time it just appears as a question mark ( ? )

I may have asked this before, but how can I add at least the iPhone emojis onto EasySocial for users to use?

Will they then still have to continue using the colon ( : ) and a letter to get the list up of emojis, or is there another way that they can see them and choose from?
Live site is now working fine with the iPhone emojis


Dev site working fine with the iPhone emojis too

Could you tell me what I would need to do to applied to masqueradedating.global please
Julie Kubiak
·
Thursday, 02 December 2021 17:37
·
0 Likes
·
0 Votes
·
0 Comments
·
It should support the emoji when the user selects the emoji from the mobile phone, perhaps you can share with me which domain site and how to reproduce this so I can better have a check?
Arlex Wong
·
Wednesday, 01 December 2021 18:57
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Arlex,

It’s the live main site, http://www.masquerading.global

I’ve attached a copy of what I can see my end, after I have posted the emojis with what they should be typed along side them.
Julie Kubiak
·
Wednesday, 01 December 2021 19:36
·
0 Likes
·
0 Votes
·
0 Comments
·
It seems like some of the table collation is not set to utf8mb4 so we can't store the emoji character in the database.

Can you do the full database backup on your site then I can help you change the table collation to utf8mb4 and see how it goes?

Also, can you update your site database login access as well?
Arlex Wong
·
Thursday, 02 December 2021 10:53
·
0 Likes
·
0 Votes
·
0 Comments
·
Live site fully backed up.

FTP login should be fine

**DEV site backed up too incase you want to test that first
Julie Kubiak
·
Thursday, 02 December 2021 14:49
·
0 Likes
·
0 Votes
·
0 Comments
·
I've helped you execute the following SQL queries on your development and live site, can you give it a try again?



ALTER TABLE `tzt4o_social_stream` CHANGE `title` `title` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

ALTER TABLE `tzt4o_social_stream` CHANGE `content` `content` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

ALTER TABLE `tzt4o_social_comments` CHANGE `comment` `comment` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
Arlex Wong
·
Thursday, 02 December 2021 16:45
·
0 Likes
·
0 Votes
·
0 Comments
·
You can execute the above SQL queries that I have shown you above.

But you have to replace the table prefix with your current table prefix e.g. tzt4o_ before executing the SQL queries from your database.
Arlex Wong
·
Thursday, 02 December 2021 17:39
·
0 Likes
·
0 Votes
·
0 Comments
·
DONE!!!!!

Thanks for your help Arlex
Julie Kubiak
·
Thursday, 02 December 2021 20:34
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome Julie, glad that your issue is resolved now.
Mark
·
Thursday, 02 December 2021 23:04
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post