Emoji give a SQL error

Discussions related to the forums itself. Call for moderators. Trash Posts area.
Post Reply
User avatar
Dustine
Long Handed Inserter
Long Handed Inserter
Posts: 60
Joined: Tue Mar 31, 2015 4:52 pm
Contact:

Emoji give a SQL error

Post by Dustine »

Image

This happened when I tried to send a post with a blue heart. Whoops.
Last edited by Dustine on Thu Oct 19, 2017 4:17 pm, edited 1 time in total.

daniel34
Global Moderator
Global Moderator
Posts: 2761
Joined: Thu Dec 25, 2014 7:30 am
Contact:

Re: Emoji give an SQL error

Post 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/
quick links: log file | graphical issues | wiki

User avatar
Dustine
Long Handed Inserter
Long Handed Inserter
Posts: 60
Joined: Tue Mar 31, 2015 4:52 pm
Contact:

Re: Emoji give an SQL error

Post 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 ^ω^.

User avatar
olafthecat
Filter Inserter
Filter Inserter
Posts: 476
Joined: Fri Jul 07, 2017 4:37 pm

Re: Emoji give a SQL error

Post by olafthecat »

Cool Emoji! :)
Gonna start playing again with 0.16 build.
That's all.

User avatar
eradicator
Smart Inserter
Smart Inserter
Posts: 5206
Joined: Tue Jul 12, 2016 9:03 am
Contact:

Re: Emoji give a SQL error

Post 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.
Author of: Belt Planner, Hand Crank Generator, Screenshot Maker, /sudo and more.
Mod support languages: 日本語, Deutsch, English
My code in the post above is dedicated to the public domain under CC0.

Post Reply

Return to “This Forum”