Emoji give a SQL error

[Dustine]

This happened when I tried to send a post with a blue heart. Whoops.

[daniel34]

Thanks for the notice.

I tried to make an answer post with the blue heart, but apparently it's not possible:


The preview function works though:


From what I can tell some of the database tables have the wrong character set / collation and don't support unicode properly. An update of the database and/or a change of collation (to utf8mb4, 4-byte utf8 encoding) is required, which would have to be done by the devs.

The emoji is this one: https://emojipedia.org/blue-heart/

[Dustine]

Thanks for the notice.

I tried to make an answer post with the blue heart, but apparently it's not possible:

The preview function works though:

From what I can tell some of the database tables have the wrong character set / collation and don't support unicode properly. An update of the database and/or a change of collation (to utf8mb4, 4-byte utf8 encoding) is required, which would have to be done by the devs.

The emoji is this one: https://emojipedia.org/blue-heart/

Yeah, I'm sorry on that I wasn't as clear as I could be on my original post, but I'm glad it ended up being replicated anyway ^ω^.

[olafthecat]

Cool Emoji!

[eradicator]

This is still broken. I just tried to answer a post with one of the three monkeys unicode characters and got a similar SQL error.

https://en.wikipedia.org/wiki/%F0%9F%99 ... characters

As an added "bonus" attaching a file with those characters in the filename also doesn't work.