Data at Your Fingertips: Explore Our New Reporting and Statistical Capabilities By Ryan Ashbrook Tuesday at 01:29 PM
iacas Posted April 26, 2018 Share Posted April 26, 2018 In announcing the 4.3 upgrade (4.3.1) to my forum, I posted a few emoji under the "emoji now supported!" sub-heading, proudly announcing support. The emoji showed up just fine in the post. I can edit the post and add them back in, in fact. ?♂️ and ?? and ?️ were among them. But when I hit submit, they showed up like this: I'm using the latest version of Safari on the latest version of macOS, which supports emoji quite well. So what is causing the issue? My forums_posts table has a "post" row with UTF-8 encoding. Should that have been converted to something else? Do other rows need to be converted to something else, too? P.S. The emoji seem to work here, at IPS. Link to comment Share on other sites More sharing options...
opentype Posted April 26, 2018 Share Posted April 26, 2018 You need utf8mb4 (for the suite and the MySQL tables), not just utf8. Link to comment Share on other sites More sharing options...
iacas Posted April 26, 2018 Author Share Posted April 26, 2018 4 minutes ago, opentype said: You need utf8mb4 (for the suite and the MySQL tables), not just utf8. Yeah, I just upgraded the posts row in the forums_posts and that seems to work. The question is then why didn't the upgrade scripts properly do this for me? I imagine there are lots of other parts where this is needed - blog posts, blog comments, gallery image comments, status updates… PMs… etc. Thank you @opentype. Link to comment Share on other sites More sharing options...
iacas Posted April 26, 2018 Author Share Posted April 26, 2018 The issue I have now is that I cannot find the script or converter to run the upgrade to utf8mb4 on all the appropriate tables. Link to comment Share on other sites More sharing options...
Nathan Explosion Posted April 26, 2018 Share Posted April 26, 2018 3 minutes ago, iacas said: The issue I have now is that I cannot find the script or converter to run the upgrade to utf8mb4 on all the appropriate tables. The option is in the ACP - can't remember where and can't locate now because all my DBs are already converted. Link to comment Share on other sites More sharing options...
iacas Posted April 26, 2018 Author Share Posted April 26, 2018 Thank you. 8 minutes ago, Nathan Explosion said: The option is in the ACP - can't remember where and can't locate now because all my DBs are already converted. In this topic… A user suggested it was in the sidebar. But my sidebar doesn't have an "Enable utf8mb4" script. ? Link to comment Share on other sites More sharing options...
Nathan Explosion Posted April 26, 2018 Share Posted April 26, 2018 Quote Dear IPS, I want to convert my database to utf8mb4 but the option to do so isn't available in the ACP. Please help Thanks, Link to comment Share on other sites More sharing options...
iacas Posted April 26, 2018 Author Share Posted April 26, 2018 @Nathan Explosion, thank you, and yes, I've already filed the support request: ? I appreciate it. Link to comment Share on other sites More sharing options...
opentype Posted April 26, 2018 Share Posted April 26, 2018 Make sure you conf_global doesn’t claim you have mb4 enabled, when that’s not actually the case. 'sql_utf8mb4' => true, Link to comment Share on other sites More sharing options...
iacas Posted April 26, 2018 Author Share Posted April 26, 2018 1 hour ago, opentype said: Make sure you conf_global doesn’t claim you have mb4 enabled, when that’s not actually the case. 'sql_utf8mb4' => true, Yeah that was it. Support was pretty quick about it. Thank you. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.