Redmine

We can reproduce this on our Redmine 4.0.7 setup, with an emoji in the title of the issue.

Up

Can reproduce it on our 5.0.5.stable
And here www.redmine.org

I convert db and all my tables to `utf8mb4` / `utf8mb4_unicode_ci` in (10.5-MariaDB)
But i still cant use emoji :-(

MySQL / MariaDB stores encoding and collations in various places, including as a database default, table default, and for each column separately. Thus, if you have an existing database, you need to transfer each text / varchar column to utf8mb4 separately.

I changed the encoding to `utf8mb4_general_ci` in every place where you can select the encoding. And in the database and in every table and in every vchar/text/long field, and still I see error 500 when I try to add emoji to any field.

I also see error 500 right here on https://www.redmine.org/ when I try to create any record with emoji.

I was able to fix this by setting REDMINE_DB_ENCODING=utf8mb4 in the docker image env, plus altering the collation of existing database and tables:

ALTER DATABASE redmine DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
ALTER TABLE issues CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE journals CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE journal_details CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

If you don't use Docker, you should probably check the config/database.yml file:

production:
  adapter: "mysql2" 
  host: "mysql" 
  port: "3306" 
  username: "redmine" 
  password: "secret" 
  database: "redmine" 
  encoding: "utf8mb4" 

the fix of Andrei Melis works fine :)

Environment:
Redmine version 5.1.2.stable
Ruby version 3.1.2-p20 (2022-04-12) [x86_64-linux-gnu]
Rails version 6.1.7.7
Environment production
Database adapter Mysql2