Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Apfelstrudel Posted December 28, 2015 Posted December 28, 2015 Hello, from my point of view the Emoji support should be included in the standard product. Especially on mobile devices the users are used to use the standard emojis instead of opening a new window for ipb smilies.
opentype Posted December 28, 2015 Posted December 28, 2015 2 minutes ago, Apfelstrudel said: Especially on mobile devices the users are used to use the standard emojis … Yes, and they/we can use that already: ? What kind of additional support are you asking for?
Apfelstrudel Posted December 28, 2015 Author Posted December 28, 2015 I'm just asking for the possibility to enter an emoji on mobile devices. At the moment an error comes up telling me that I entered an invalid character such an Emoji.
opentype Posted December 28, 2015 Posted December 28, 2015 What MySQL version are you running? If it’s too old, Emoji are not supported and IPS will throw that error. It’s then a limitation of the database, not the IPS software.
Apfelstrudel Posted December 28, 2015 Author Posted December 28, 2015 Oh, I didn't know that. Thanks for this information. We're running mysql 5.1 (in utf8).
-FP Posted December 28, 2015 Posted December 28, 2015 I made the mistake of not converting the database to support this when I upgraded from 3.4.x and I'm still waiting for a reliable solution to this since IPS4 went gold...
Apfelstrudel Posted December 28, 2015 Author Posted December 28, 2015 Which version is necessary for supporting Emojis?
-FP Posted December 28, 2015 Posted December 28, 2015 2 minutes ago, Apfelstrudel said: Which version is necessary for supporting Emojis? Database needs to be utf8mb4, not just utf8.
Apfelstrudel Posted December 28, 2015 Author Posted December 28, 2015 Is there any way to convert a db?
-FP Posted December 28, 2015 Posted December 28, 2015 5 minutes ago, Apfelstrudel said: Is there any way to convert a db? You choose to convert it when you upgrade from 3.x or you choose it when you make a new IPS4 install. As far as I know there's nothing "oficial" from IPS to convert a database other than the 2 cases mentioned above, we could use a tool for that...
opentype Posted December 28, 2015 Posted December 28, 2015 It won’t work on 5.1 at all. It’s just not supported. You need to upgrade the DB first before being able to convert to mb4.
Mark Posted December 28, 2015 Posted December 28, 2015 You need to be using MySQL 5.5.3 or higher and have all tables and columns using the utf8mb4 character set. If you are running MySQL 5.5.3 or higher when you install IPS Community Suite or upgrade from IP.Board, you will have the option to use utf8mb4. If you upgrade later, you would need to modify the database manually (there is a good guide here). It would probably be handy to have a script to do this though - I'll bring it up for discussion
simonle Posted December 28, 2015 Posted December 28, 2015 34 minutes ago, Mark said: It would probably be handy to have a script to do this though - I'll bring it up for discussion Yes, please do so!
Tracy Perry Posted December 28, 2015 Posted December 28, 2015 Phoca seems to work fine for simple stuff like this.
Jujuwar Posted January 10, 2016 Posted January 10, 2016 @Mark have you got any news about this? On 28/12/2015 at 1:29 PM, Mark said: It would probably be handy to have a script to do this though - I'll bring it up for discussion
SJ77 Posted January 11, 2016 Posted January 11, 2016 On December 28, 2015 at 2:19 AM, -FP said: Database needs to be utf8mb4, not just utf8. I wish I would have known this. I upgraded only to UTF8 because I thought the only reason for the larger utf8mb4 was to support rare music symbols. I didn't know I would be missing out on this. Ugh, can I upgrade?
Mark Posted January 11, 2016 Posted January 11, 2016 We would like to do this but we don't have an ETA. utf8mb4 is a superset of utf8 so converting should be simple - it's just the indexes are a pain. If you feel up to doing it manually, MySQL does have a guide on their site, or you could use a script like the one @Tracy Perry mentioned.
Cybero Posted January 12, 2016 Posted January 12, 2016 Hi, I choose to convert my database to utf8mb4 during 3.4 to 4.0 upgrade Some Emoji works and others no... It says: Quote The value entered includes a character that is not allowed such as an Emoji. What does I need to do to correctly support emojis ? Regards
opentype Posted January 12, 2016 Posted January 12, 2016 12 minutes ago, Cybero said: Some Emoji works and others no... Can you give examples? And how do you define “work” in that case? The IPS support is about storing it correctly in an utf8mb4 database (and denying the input if that database encoding is not present), not about displaying the Emoji, which also depends on your browser and the (Emoji) fonts you have installed.
Cybero Posted January 12, 2016 Posted January 12, 2016 For example this one is working (I can post and see it from my android browser (chrome) with SwiftKey keyboard) on my forum: ✈ But I can't post this one ? When I submit message, I have the following error ans message is not posted Quote The value entered includes a character that is not allowed such as an Emoji.
opentype Posted January 12, 2016 Posted January 12, 2016 Yeah, this looks like the expected result of NOT running utf8mb4. The airplane is just U+2708 and will work, but the smiley is on a higher Unicode plane (U+1F604) and will not work, that’s why the IPS software doesn’t even accept it. It just couldn’t be stored in the database.
Cybero Posted January 12, 2016 Posted January 12, 2016 Oh ok that explains What can I check to see if my database is utf8mb4 ? By the way, thanks for your answers Edit: OK my bad... the following line was commented in my conf_global.php $INFO['sql_utf8mb4'] = true; I uncommented it and now it works !
Apfelstrudel Posted February 12, 2016 Author Posted February 12, 2016 On 28. Dezember 2015 at 1:29 PM, Mark said: It would probably be handy to have a script to do this though - I'll bring it up for discussion Mark, any news on this?
Kjell Iver Johansen Posted February 13, 2016 Posted February 13, 2016 I just noticed that one of my boards have Emojisupport - the others don't. Both upgrades been done by IPS - and they are on the same server and setup. I can't recall I ever had the opportunity to select that myselve. I hope IPS comes up with a converter of some kind also.
Lenny Warren Posted February 13, 2016 Posted February 13, 2016 I noticed I have mine set to false. presuming it's not as easy as changing this to true? The database would have to be updated first? $INFO['sql_utf8mb4'] = true;
Recommended Posts
Archived
This topic is now archived and is closed to further replies.