https://www.redmine.org/
https://www.redmine.org/favicon.ico?1679302129
2015-01-16T10:42:02Z
Redmine
Redmine - Defect #18866: MySQL: disappear after 4-Byte UTF-8
https://www.redmine.org/issues/18866?journal_id=60894
2015-01-16T10:42:02Z
Алексей Городецкий
<ul></ul><p><a class="user active" href="https://www.redmine.org/users/36659">林 业文</a> writing tasks text after some characters disappear. For example, after the symbol «</p>
Redmine - Defect #18866: MySQL: disappear after 4-Byte UTF-8
https://www.redmine.org/issues/18866?journal_id=60895
2015-01-16T13:28:14Z
Toshi MARUYAMA
<ul></ul><p>after the symbol « after the symbol « after the symbol «</p>
Redmine - Defect #18866: MySQL: disappear after 4-Byte UTF-8
https://www.redmine.org/issues/18866?journal_id=60896
2015-01-16T13:30:38Z
Toshi MARUYAMA
<ul><li><strong>File</strong> <a href="/attachments/12982">issue.png</a> <a class="icon-only icon-download" title="Download" href="/attachments/download/12982/issue.png">issue.png</a> added</li><li><strong>Status</strong> changed from <i>New</i> to <i>Needs feedback</i></li></ul><p>I cannot reproduce.</p>
<p><img src="https://www.redmine.org/attachments/download/12982/issue.png" alt="" /></p>
<pre>
Environment:
Redmine version 2.5.3.stable
Ruby version 1.9.3-p551 (2014-11-13) [x86_64-linux]
Rails version 3.2.19
Environment production
Database adapter Mysql2
SCM:
Subversion 1.6.11
Mercurial 2.8.2
Bazaar 2.1.1
Git 1.7.1
Filesystem
Redmine plugins:
no plugin installed
</pre>
Redmine - Defect #18866: MySQL: disappear after 4-Byte UTF-8
https://www.redmine.org/issues/18866?journal_id=60937
2015-01-18T15:49:33Z
Имя Фамилия
<ul></ul><p>For example, after the symbol "􀀀". This symbol was been encoded for this message as <pre>&#x100000;</pre>. Copy this message to reproduce.</p>
Redmine - Defect #18866: MySQL: disappear after 4-Byte UTF-8
https://www.redmine.org/issues/18866?journal_id=60938
2015-01-18T15:53:22Z
Имя Фамилия
<ul></ul><p>Copy:<br />For example, after the symbol "</p>
Redmine - Defect #18866: MySQL: disappear after 4-Byte UTF-8
https://www.redmine.org/issues/18866?journal_id=60939
2015-01-18T16:57:18Z
Toshi MARUYAMA
<ul><li><strong>Category</strong> changed from <i>Issues</i> to <i>Database</i></li><li><strong>Status</strong> changed from <i>Needs feedback</i> to <i>New</i></li></ul><p>The utf8mb4 Character Set (4-Byte UTF-8 Unicode Encoding)<br /><a class="external" href="http://dev.mysql.com/doc/refman/5.6/en/charset-unicode-utf8mb4.html">http://dev.mysql.com/doc/refman/5.6/en/charset-unicode-utf8mb4.html</a></p>
Redmine - Defect #18866: MySQL: disappear after 4-Byte UTF-8
https://www.redmine.org/issues/18866?journal_id=60940
2015-01-18T17:00:21Z
Toshi MARUYAMA
<ul></ul><p><a class="external" href="http://www.fileformat.info/info/unicode/char/100000/index.htm">http://www.fileformat.info/info/unicode/char/100000/index.htm</a></p>
<blockquote>
<p>UTF-8 (hex) 0xF4 0x80 0x80 0x80 (f4808080)</p>
</blockquote>
Redmine - Defect #18866: MySQL: disappear after 4-Byte UTF-8
https://www.redmine.org/issues/18866?journal_id=60941
2015-01-18T17:01:22Z
Toshi MARUYAMA
<ul><li><strong>Subject</strong> changed from <i>When writing tasks text disappears after some characters</i> to <i>MySQL: disappear after 4-Byte UTF-8</i></li></ul>
Redmine - Defect #18866: MySQL: disappear after 4-Byte UTF-8
https://www.redmine.org/issues/18866?journal_id=63490
2015-05-03T00:01:22Z
Toshi MARUYAMA
<ul><li><strong>Related to</strong> <i><a class="issue tracker-3 status-5 priority-4 priority-default closed" href="/issues/19742">Patch #19742</a>: RedmineInstall: MySQL: collation_database</i> added</li></ul>
Redmine - Defect #18866: MySQL: disappear after 4-Byte UTF-8
https://www.redmine.org/issues/18866?journal_id=64347
2015-06-22T03:49:09Z
Toshi MARUYAMA
<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>
Redmine - Defect #18866: MySQL: disappear after 4-Byte UTF-8
https://www.redmine.org/issues/18866?journal_id=64348
2015-06-22T03:49:27Z
Toshi MARUYAMA
<ul><li><strong>Is duplicate of</strong> <i><a class="issue tracker-1 status-5 priority-4 priority-default closed" href="/issues/10772">Defect #10772</a>: 4-byte utf-8 characters</i> added</li></ul>
Redmine - Defect #18866: MySQL: disappear after 4-Byte UTF-8
https://www.redmine.org/issues/18866?journal_id=64351
2015-06-22T03:49:31Z
Toshi MARUYAMA
<ul><li><strong>Related to</strong> deleted (<i><a class="issue tracker-3 status-5 priority-4 priority-default closed" href="/issues/19742">Patch #19742</a>: RedmineInstall: MySQL: collation_database</i>)</li></ul>
Redmine - Defect #18866: MySQL: disappear after 4-Byte UTF-8
https://www.redmine.org/issues/18866?journal_id=64352
2015-06-22T03:51:27Z
Toshi MARUYAMA
<ul><li><strong>Status</strong> changed from <i>Closed</i> to <i>New</i></li><li><strong>Resolution</strong> deleted (<del><i>Duplicate</i></del>)</li></ul>
Redmine - Defect #18866: MySQL: disappear after 4-Byte UTF-8
https://www.redmine.org/issues/18866?journal_id=64358
2015-06-22T03:55:30Z
Toshi MARUYAMA
<ul><li><strong>Related to</strong> <i><a class="issue tracker-3 status-5 priority-4 priority-default closed" href="/issues/19742">Patch #19742</a>: RedmineInstall: MySQL: collation_database</i> added</li></ul>
Redmine - Defect #18866: MySQL: disappear after 4-Byte UTF-8
https://www.redmine.org/issues/18866?journal_id=64362
2015-06-22T03:58:30Z
Toshi MARUYAMA
<ul></ul><p>Try utf8mb4 (<a class="issue tracker-1 status-5 priority-4 priority-default closed" title="Defect: 4-byte utf-8 characters (Closed)" href="https://www.redmine.org/issues/10772#note-7">#10772#note-7</a>).</p>
Redmine - Defect #18866: MySQL: disappear after 4-Byte UTF-8
https://www.redmine.org/issues/18866?journal_id=64365
2015-06-22T04:00:02Z
Toshi MARUYAMA
<ul><li><strong>Has duplicate</strong> <i><a class="issue tracker-1 status-5 priority-4 priority-default closed" href="/issues/10779">Defect #10779</a>: redmine cannot deal with 4-byte utf-8 characters</i> added</li></ul>
Redmine - Defect #18866: MySQL: disappear after 4-Byte UTF-8
https://www.redmine.org/issues/18866?journal_id=64366
2015-06-22T04:03:44Z
Toshi MARUYAMA
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Closed</i></li></ul>
Redmine - Defect #18866: MySQL: disappear after 4-Byte UTF-8
https://www.redmine.org/issues/18866?journal_id=64368
2015-06-22T04:04:58Z
Toshi MARUYAMA
<ul><li><strong>Status</strong> changed from <i>Closed</i> to <i>New</i></li></ul>
Redmine - Defect #18866: MySQL: disappear after 4-Byte UTF-8
https://www.redmine.org/issues/18866?journal_id=64370
2015-06-22T04:05:51Z
Toshi MARUYAMA
<ul><li><strong>Has duplicate</strong> deleted (<i><a class="issue tracker-1 status-5 priority-4 priority-default closed" href="/issues/10779">Defect #10779</a>: redmine cannot deal with 4-byte utf-8 characters</i>)</li></ul>
Redmine - Defect #18866: MySQL: disappear after 4-Byte UTF-8
https://www.redmine.org/issues/18866?journal_id=64371
2015-06-22T04:06:47Z
Toshi MARUYAMA
<ul><li><strong>Is duplicate of</strong> deleted (<i><a class="issue tracker-1 status-5 priority-4 priority-default closed" href="/issues/10772">Defect #10772</a>: 4-byte utf-8 characters</i>)</li></ul>
Redmine - Defect #18866: MySQL: disappear after 4-Byte UTF-8
https://www.redmine.org/issues/18866?journal_id=64374
2015-06-22T04:07:26Z
Toshi MARUYAMA
<ul><li><strong>Has duplicate</strong> <i><a class="issue tracker-1 status-5 priority-4 priority-default closed" href="/issues/10779">Defect #10779</a>: redmine cannot deal with 4-byte utf-8 characters</i> added</li></ul>
Redmine - Defect #18866: MySQL: disappear after 4-Byte UTF-8
https://www.redmine.org/issues/18866?journal_id=64376
2015-06-22T04:08:36Z
Toshi MARUYAMA
<ul><li><strong>Has duplicate</strong> <i><a class="issue tracker-1 status-5 priority-4 priority-default closed" href="/issues/10772">Defect #10772</a>: 4-byte utf-8 characters</i> added</li></ul>
Redmine - Defect #18866: MySQL: disappear after 4-Byte UTF-8
https://www.redmine.org/issues/18866?journal_id=68358
2016-01-08T16:01:52Z
Toshi MARUYAMA
<ul><li><strong>Has duplicate</strong> <i><a class="issue tracker-1 status-5 priority-4 priority-default closed" href="/issues/21679">Defect #21679</a>: Emoji [CL] will break the subject of new tickets</i> added</li></ul>
Redmine - Defect #18866: MySQL: disappear after 4-Byte UTF-8
https://www.redmine.org/issues/18866?journal_id=93184
2019-08-17T16:20:58Z
Marius BĂLTEANU
<ul><li><strong>Related to</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 #18866: MySQL: disappear after 4-Byte UTF-8
https://www.redmine.org/issues/18866?journal_id=111574
2023-11-20T23:17:33Z
Marius BĂLTEANU
<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>Issues <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>, <a class="issue tracker-2 status-5 priority-4 priority-default closed" title="Feature: Document MySQL database migration to utf8mb8 (Closed)" href="https://www.redmine.org/issues/32140">#32140</a> and <a class="wiki-page" href="https://www.redmine.org/projects/redmine/wiki/HowTo_convert_a_database_from_utf8_to_utf8mb4">HowTo_convert_a_database_from_utf8_to_utf8mb4</a> page contain enough information to identify the issues caused by utf8 and to migrate the database to utf8mb4.</p>
<p>Closing this as duplicate.</p>