Emojis are converted to question-marks in repository description

[jonasfranz]

• Gitea version (or commit ref): f3833b7
• Operating system: GNU/Linux
• Database (use [x]):
  • MySQL
• Can you reproduce the bug at https://try.gitea.io:
  • No
• Log gist: Not relevant

Description

It result into the following: "????App for iOS" if you want to add emojis to your repository description like "📱App for iOS".

Emojis in the description could be useful like seen at the ownCloud Github Project (https://github.com/owncloud).

This might be caused by the used MySQL database.

[lunny]

So maybe mysql database should be utf8mb4?

[kolaente]

I had a similar issue, but in my case the description was completly deleted when I added an emoji to the repo description (v1.4-rc-2). Seems to work fine on master with sqlite though.

[lunny]

This should be fixed by #5168, please feel free to reopen it.

[lunny]

If you input :smile: that right for repo description, but if you paste from your clipboard, that will fail.

[immanuelfodor]

I can confirm this on v1.6.2, any emoji copypasted from e.g. https://emojipedia.org becomes ????. Only the manually typed :emojicode: works fine. This issue is also present at eg. org descriptions, copypasted emojis become question marks. Screenshot from an issue comment:

[lunny]

So should we parse the copypasted emojis to :emojicode: before save it?