openSUSE admin

Hi,

thanks for making the ticket.

I found why it works in comments, but not in ticket descriptions:

MariaDB [redmine]> SHOW TABLE STATUS LIKE 'journal_details'\G;
...
       Collation: latin1_swedish_ci
...

MariaDB [redmine]> SHOW TABLE STATUS LIKE 'comments'\G;
...
       Collation: utf8mb4_unicode_ci
...

I will try to convert the journal_details table to either utf8mb4_unicode_ci, or, if possible, the more modern utf8mb4_unicode_520_ci.

One backup and a few seconds later

MariaDB [redmine]> ALTER TABLE journal_details CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
Query OK, 249388 rows affected (1.362 sec)
Records: 249388  Duplicates: 0  Warnings: 0

this is now done.

Tested here - both with your systemctl status example and with emojies: https://progress.opensuse.org/issues/157828.

Please confirm on your end as well and let me know.

Great, thanks for confirming!