Japanese Emoticon characters cause error in issue desc and journal
When I add the following string to a new issue or the journal note for an issue it throws an error. Looking at documentation here I believe it is to do with the fact that my Bitnami stack creates the tables in mysql utf8 which is 3 byte not 4 byte. This given, could we patch or add code or an option so that, in that case, it simply converts any bad characters to ? - I see code that does that anyway so I'm not sure why that isn't happening automatically.
The text is this -
Here is the character that causes a problem with mysql utf-8 tables
#4 Updated by Matthew Paul 11 months ago
Adding good info from a forum message in case anyone else is searching issues -
#21398#note-10 in particular goes into a good level of detail.
We experience this with scraped emails (they're rejected) and attempts to post to an issue via the web UI (500 server error).