Redmine

Try to add a thumbs up character. The version installed at my company will give an error page. The version on this website will show nothing.

https://emojipedia.org/thumbs-up-sign/

I think is the same as #21398. People posted some workarounds there.

Test if working on redmine.org: Comment that contains certain Unicode characters can't be saved. Here we are:

Marco Shima wrote:

Test if working on redmine.org: Comment that contains certain Unicode characters can't be saved. Here we are:

It was really lost. There was a character `U+1F442` after the "Here we are:" which is lost upon save.

Duplicate:
- https://www.redmine.org/issues/25116#change-105522
- https://www.redmine.org/issues/11191#change-105521

Mail + Normal post

Solution: Convert table to utf8mb and set in file database.yml "encoding: utf8mb4"

Hello, the solution may fix the issue but you could be more precise by giving the required command or sql query to run please.

I think the wiki and other contents should be fixed. So we could apply a conversion to table "issues" and all others ?