Emojis in game chat
Emojis in game chat
Game chat does not support emojis! How are we supposed to negotiate a difficult situation?
- dargorygel
- Site Moderator
- Posts: 6682
- Joined: Mon Dec 18, 2017 1:55 pm
- Location: Over the rainbow
- Contact:
Re: Emojis in game chat
I find :^) has an ~80% chance to instantly sour negotiations when used but I just can't help myself.
-
- Posts: 225
- Joined: Thu Jan 31, 2019 7:00 am
- Contact:
-
- Silver Donator
- Posts: 293
- Joined: Sun Jun 10, 2018 8:43 pm
- Location: The netherlands
- Contact:
Re: Emojis in game chat
You don't need those pesky round emojis.
look at all this passion and sheer emotion conveyed between these two countries:
?!!
(ノ°Д°)ノ︵ ┻━┻
___________
:/
___________
(;⌣̀_⌣́)
___________
:P
___________
-_-
___________
;)
___________
(凸ಠ益ಠ)︻デ═== ✴
look at all this passion and sheer emotion conveyed between these two countries:
?!!
(ノ°Д°)ノ︵ ┻━┻
___________
:/
___________
(;⌣̀_⌣́)
___________
:P
___________
-_-
___________
;)
___________
(凸ಠ益ಠ)︻デ═== ✴
Re: Emojis in game chat
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
-
- Site Contributor
- Posts: 245
- Joined: Tue Mar 14, 2017 8:44 pm
- Contact:
Re: Emojis in game chat
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.
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
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
-
- Site Contributor
- Posts: 245
- Joined: Tue Mar 14, 2017 8:44 pm
- Contact:
Re: Emojis in game chat
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.
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.
Who is online
Users browsing this forum: No registered users