Emojis in game chat

Post a reply

Confirmation code
Enter the code exactly as it appears. All letters are case insensitive.
Smilies
:points: :-D :eyeroll: :neutral: :nmr: :razz: :raging: :-) ;) :( :sick: :o :? 8-) :x :shock: :lol: :cry: :evil: :?: :smirk: :!:
View more smilies

BBCode is ON
[img] is ON
[flash] is OFF
[url] is OFF
Smilies are ON

Topic review
   

If you wish to attach one or more files enter the details below.

Expand view Topic review: Emojis in game chat

Re: Emojis in game chat

by Claesar » Sun Aug 23, 2020 7:10 pm

Viaduct

Re: Emojis in game chat

by Peregrine Falcon » Sun Aug 23, 2020 6:21 pm

Oh lol I just hadn't looked closely enough at the db connection before and missed where it specified the encoding.

The table encoding just needs to be converted to utf8mb4 in mySQL, then database.php has to change set names from utf8 to utf8mb4 on line 118.

That made the full unicode display properly on my test server.

Re: Emojis in game chat

by A_Tin_Can » Sun Aug 23, 2020 3:21 pm

There are a few places you might need to put it - take a look at eg: https://www.toptal.com/php/a-utf-8-prim ... -and-mysql

Re: Emojis in game chat

by Peregrine Falcon » Sun Aug 23, 2020 2:34 pm

It's actually worse than just not having emojis display properly. They actually completely break off the message being posted—only the text before the emoji makes it into the db.

Most webDip tables, particularly the wd_gamemessages table, are set to utf8. They should really be converted to the standard collation utf8mb4_0900_ai_ci. (Due to a weird and annoying quirk of MySQL naming, the utf8 character set is not actually utf-8-compliant. The newer utf8mb4 set is what's actually needed... /facepalm_emoji)

That said, when I made the change on my test server, emojis were no longer cutting off the message, which is good, but still were only showing as ???? and I'm not sure why.

Re: Emojis in game chat

by A_Tin_Can » Sun Aug 23, 2020 7:39 am

As a workaround, you can just write out "eggplant" as necessary.

Re: Emojis in game chat

by A_Tin_Can » Sun Aug 23, 2020 7:38 am

I think this is just because of the character set on the database and DB table used to store the messages. Something like this would probably work to fix it: https://stackoverflow.com/questions/394 ... l-database

Re: Emojis in game chat

by e.m.c^42 » Wed Oct 09, 2019 12:23 pm

You don't need those pesky round emojis.

look at all this passion and sheer emotion conveyed between these two countries:

?!!
(ノ°Д°)ノ︵ ┻━┻

___________

:/
___________

(;⌣̀_⌣́)
___________

:P
___________

-_-
___________

;)
___________

(凸ಠ益ಠ)︻デ═== ✴

Re: Emojis in game chat

by tobieee911 » Wed Oct 09, 2019 9:32 am

lol

Re: Emojis in game chat

by Foldemort » Wed Oct 09, 2019 9:25 am

8=======D (an army tank with a long cannon)

Re: Emojis in game chat

by Restitution » Mon Oct 07, 2019 8:26 pm

))<>((

Re: Emojis in game chat

by bunp » Mon Oct 07, 2019 7:57 pm

I find :^) has an ~80% chance to instantly sour negotiations when used but I just can't help myself.

Re: Emojis in game chat

by dargorygel » Fri Oct 04, 2019 12:04 am

The old school way... : - )

Emojis in game chat

by alamothe » Thu Oct 03, 2019 10:16 pm

Game chat does not support emojis! How are we supposed to negotiate a difficult situation?

Top