Questions about the Mysql character set

Question

When can I support utf8mb4, the problem I am facing now is that I can't insert an emoticon in the document, and I will get an error if I insert the emoticon.
Incorrect string value: '\xF0\x9F\x98\x82\xF0\x9F

Trying to install the latest version will not help

Mirek · Answer

Confluence supports MySQL..

https://confluence.atlassian.com/doc/supported-platforms-207488198.html

And MySQL is able to use utf8mb4, so if everything is set correctly in your database there should not be a problem. If there is any (and you are using supported versions and have active maintenence) I suggest to get all the logs and contact Atlassian support to help verify if this is really a problem with utf8mb4..

刘祥亮_ijpiwa · Answer

Thank you for your answer. I have read these documents before and can't solve my problem. I just want to know if confluence does not support utf8mb4.

Mirek · Answer

Hi,

Did you check those KB articels?

https://confluence.atlassian.com/jirakb/emojis-and-special-characters-for-jira-with-mysql-952604493.html

https://confluence.atlassian.com/fishkb/migrate-mysql-database-to-utf8mb4-character-encoding-962356253.html