[buddypress-trac] [BuddyPress Trac] #6346: Upgrade DB tables to utf8mb4

[buddypress-trac]

#6346: Upgrade DB tables to utf8mb4
---------------------------------+------------------
 Reporter:  DJPaul               |       Owner:
     Type:  enhancement          |      Status:  new
 Priority:  normal               |   Milestone:  2.5
Component:  Component - Any/All  |     Version:
 Severity:  major                |  Resolution:
 Keywords:  needs-patch          |
---------------------------------+------------------

Comment (by r-a-y):

 > If someone is posting content with Emojies in e.g. bbpress,
 `$wpdb->query()` returns false and BuddyPress fails silently without
 creating the activity in `BP_Activity_Activity->save()`

 This isn't just specific to emojis.

 If a hex character prefixed with A-F is used in the content:
 http://www.ascii.cl/htmlcodes.htm

 `bp_activity_add()` fails silently as well.  I've attached a unit test
 exhibiting this problem.  This test can be fixed temporariliy by using
 `htmlentities()` before inserting the activity item:
 `add_filter( 'bp_activity_content_before_save', 'htmlentities' );` (This
 doesn't fix the emojis problem)

 I ran into this problem with the WP Front-end Editor plugin with BP
 activity integration.

 Upgrading our activity DB tables might also fix this.

 FYI, `wp_insert_post()` also fails with this test content as well.  So
 maybe we don't want to do anything here and leave it to plugins to
 properly encode characters before insertion?

--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/6346#comment:18>
BuddyPress Trac <http://buddypress.org/>
BuddyPress Trac