mChat

mChat unicode emojy compatibiity - mChat

mChat unicode emojy compatibiity

by Anonymous » Tue Nov 21, 2017 2:14 am

Hi everyone,

Since I wanted to add an emojy-picker to my board and phpbb3.2 doesnt support it by default, I used this one : emojionearea

I know phpbb3.2 supports unicode emojy thanks to the text-formatter it uses, in fact if I input an unicode emojy directly in a post/message it works.

However, if I input by c&p an unicode emojy to mChat (for example 😀), it fails sending the message with the following ajax error:
SQL ERROR [ mysqli ]<br /><br />Incorrect string value: '\xF0\x9F\x98\x80' for column 'message' at row 1


Can this be fixed? Thank you :)
Anonymous
I am too lazy to register
Posts: 3107
Joined: Thu Mar 15, 2007 6:50 am
Contact:

Re: mChat unicode emojy compatibiity

by Anonymous » Tue Nov 21, 2017 5:35 pm

update : even by removing every extension, cleaning mChat, couldnt get it to work. Tested with a fresh forum and database, same host, was working fine.

Added the theme Im using, the extensions....everything was working fine for two hours, then it happened again.
Anonymous
I am too lazy to register
Posts: 3107
Joined: Thu Mar 15, 2007 6:50 am
Contact:

Re: mChat unicode emojy compatibiity

by Anonymous » Tue Nov 21, 2017 5:42 pm

this is the full error :

SQL ERROR [ mysqli ]<br /><br />Incorrect string value: '\xF0\x9F\x98\x84' for column 'message' at row 1 [1366]<br /><br />SQL<br /><br />INSERT INTO phpbb_mchat (message, bbcode_bitfield, bbcode_uid, bbcode_options, user_id, user_ip, message_time) VALUES ('😄.....

and the console is showing : Failed to load resource: the server responded with a status of 503 (Service Unavailable)

also normal emojy ( like :D ) doesnt get parsed

could be because i have an htaccess password set when accessing the forum root?
Anonymous
I am too lazy to register
Posts: 3107
Joined: Thu Mar 15, 2007 6:50 am
Contact:

Re: mChat unicode emojy compatibiity

by kasimi » Sat Dec 09, 2017 1:16 pm

It works fine with MySQL. When I send an emoji, the message row in the database looks like this:

Code: Select all

<r><EMOJI seq="1f621">&#128545;</EMOJI></r>
Which emoji are you sending? What DBMS are you using?
User avatar
kasimi
Extension Customisations
Extension Customisations
Posts: 2475
Joined: Sat Sep 10, 2011 7:12 pm
Location: Germany
Contact: