https://www.redmine.org/https://www.redmine.org/favicon.ico?16793021292020-06-23T10:08:17ZRedmineRedmine - Defect #33649: Ascii code in the 'Description' causes 500 errorhttps://www.redmine.org/issues/33649?journal_id=983262020-06-23T10:08:17ZHolger Just
<ul><li><strong>Is duplicate of</strong> <i><a class="issue tracker-2 status-5 priority-4 priority-default closed" href="/issues/31921">Feature #31921</a>: Changes to properly support 4 byte characters (emoji) when database is MySQL</i> added</li></ul> Redmine - Defect #33649: Ascii code in the 'Description' causes 500 errorhttps://www.redmine.org/issues/33649?journal_id=983282020-06-23T10:08:21ZHolger Just
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Closed</i></li><li><strong>Resolution</strong> set to <i>Duplicate</i></li></ul><p>Sometimes (especially when using an older database with MySQL), the underlying database only supports the storage of up to three-byte UTF-8 characters. However, some characters (such as the LEFTWARDS HEAVY ARROW) require four bytes of storage.</p>
<p>To be able to enter those characters, you would need to upgrade your existing database to support 4 bute characters. This means you need to change the collation of the rows from `utf8` to `utf8mb4`. To be ablt to do that, you also need to use row_format = DYNAMIC and the Baracuda file format).</p>
<p>Please see <a class="issue tracker-2 status-5 priority-4 priority-default closed" title="Feature: Changes to properly support 4 byte characters (emoji) when database is MySQL (Closed)" href="https://www.redmine.org/issues/31921">#31921</a> and <a class="external" href="http://blog.andriylesyuk.com/4-byte-utf-8-problem-in-redmine-and-how-to-fix-it/">http://blog.andriylesyuk.com/4-byte-utf-8-problem-in-redmine-and-how-to-fix-it/</a> for some details on how to migrate your existing database. Before performing these changes, please make sure that you have a full and working backup of your database so that you can revert to that backup in case anything goes wrong.</p>