blog documentation FAQ followers forum marketplace services youtube

solved I-Pad Smiley truncates text in comment field?

The Jamroom Network » Forum » Using Jamroom » Page » I-Pad Smiley truncates text in comment field?
lornawebber
@lornawebber
8 years ago
334 posts
This has been reported by one of our users, unfortunately I can't test as I don't have an i-Pad. Is it a fault?

Example...
Comment text with Smiley face added from site's comment box looks like this:
> "Didn't go to the 30 30 yesterday.
> At least we have a nice little group who are keen. [smiley face symbol]
> Sometimes you need a reason! I'm glad we decided to set it up."

If the Smiley is added from i-Pad's smiley faces, the comment looks like this:

> "Didn't go to the 30 30 yesterday.
> At least we have a nice little group who are keen."


It seems that if a person uses the Apple smileys, the smiley and any words after it disappear.
updated by @lornawebber: 05/16/16 01:32:59AM
Strumelia
Strumelia
@strumelia
8 years ago
3,603 posts
Yes this happens, I just tested this on my ipad. I tested it both in a comment on a Group Comment wall, and in a post in a Group Forum discussion. I have not tested it in a Forums thread, but would expect the same.

"if a person uses the Apple smileys, the smiley and any words after it disappear."


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015
paul
@paul
8 years ago
4,326 posts
Thanks - We'll check that out (as soon as I find my iPad - not seen it for a few weeks!!)


--
Paul Asher - JR Developer and System Import Specialist
brian
@brian
8 years ago
10,148 posts
The problem here is that these are not Jamroom "smileys" - these are "emoji" from the iPad keyboard, and unfortunately MySQL older than 5.5.3 does NOT support the proper utf-8 encoding needed to store these emoji in the database.

This is something I have already worked on for 5.3, but the "solution" in 5.3 is going to be to strip the emoji from the string (so at least the rest of the text is inserted).

Post 5.3 we will look at updates that will allow emoji to be stored for those systems that are on MySQL 5.5.3 and newer (it will require conversion of storage encoding from utf8 to utf8mb4).

Let me know if that helps.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
lornawebber
@lornawebber
8 years ago
334 posts
Yes thanks @Brian. Better to lose an emoji than the text, certainly.
Strumelia
Strumelia
@strumelia
8 years ago
3,603 posts
Agreed.


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015
brian
@brian
8 years ago
10,148 posts
I've got a new system in place for JR 5.3.1 that will handle emoji's - were in the process of testing it right now, but this should be fixed fairly soon.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
brian
@brian
8 years ago
10,148 posts
Emoji should be working now in JR 5.3.1.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

Tags