Page 1 of 1

Emoji give a SQL error

Posted: Thu Oct 19, 2017 2:28 pm
by Dustine
Image

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

Re: Emoji give an SQL error

Posted: Thu Oct 19, 2017 3:57 pm
by daniel34
Thanks for the notice.

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

The preview function works though:
Image

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/

Re: Emoji give an SQL error

Posted: Thu Oct 19, 2017 4:16 pm
by Dustine
daniel34 wrote: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 ^ω^.

Re: Emoji give a SQL error

Posted: Sat Oct 21, 2017 5:07 pm
by olafthecat
Cool Emoji! :)

Re: Emoji give a SQL error

Posted: Sun Nov 19, 2017 11:05 pm
by 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.