[wp-trac] [WordPress Trac] #36456: oEmbeds containing Emojis aren't cached if the meta_value column's charset is utf8 and not utf8mb4

[WordPress Trac]

#36456: oEmbeds containing Emojis aren't cached if the meta_value column's charset
is utf8 and not utf8mb4
--------------------------+------------------------------
 Reporter:  birgire       |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Embeds        |     Version:  4.4.2
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:
--------------------------+------------------------------

Comment (by birgire):

 @Krstarica, I think this is still problematic for non utf8mb4.

 Just imagine a popular site, with an uncached frontpage, displaying full
 content posts, each containing multiple Instagram oEmbeds with Emojis ;-)

 Note that the Instagram oEmbeds can contain other invalid chars than just
 Emojis, so I ended up using  {{{mb_convert_encoding()}}}, like mentioned
 here:  http://stackoverflow.com/a/34640424/2078474


 Then JetPack complicated things further, because it's using it's own
 Instagram handler, if I remember correctly. I therefore had to unload it
 through the {{{jetpack_shortcodes_to_include}}} filter, to be apply the
 {{{mb_convert_encoding()}}} to fix through the {{{oembed_result}}} filter.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/36456#comment:5>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform