webdiplomacy.net

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

The old school way... : - )

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

))<>((

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

lol

You don't need those pesky round emojis.

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

?!!
(ノ°Д°）ノ︵ ┻━┻
___________

:/
___________

(；⌣̀_⌣́)
___________

:P
___________

-_-
___________

;)
___________

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

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

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

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.

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

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.

Viaduct