Twitter shortcode fails when emoji in tweet
[Perch Runway 3.0.11, Perch Twitter 4.0]
I haven't done a lot of testing, but it seems that a SQL query is failing when there is an emoji in the tweet retrieved by a Perch Twitter shortcode, and the content is failing to save.
Here is one such tweet:
Perch debug output is
Invalid query: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF0\x9F\x98\x8D p...' for column 'itemSearch' at row 1, so I think the conversion of the emoji to text for the search index is breaking the query.
Can anyone confirm?
Edit: I copy-pasted the full SQL query from the Perch debug output, removed the emoji and ran it directly on the db, and it succeeded, which is what leads me to believe it's the emoji causing the problem.