Vote #75947
未完了MySQL: disappear after 4-Byte UTF-8
0%
journals
@When writing tasks text after some characters disappear. For example, after the symbol «
--------------------------------------------------------------------------------
after the symbol « after the symbol « after the symbol «
--------------------------------------------------------------------------------
I cannot reproduce.
!issue.png!
<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>
--------------------------------------------------------------------------------
For example, after the symbol "􀀀". This symbol was been encoded for this message as <pre>􀀀</pre>. Copy this message to reproduce.
--------------------------------------------------------------------------------
Copy:
For example, after the symbol "
--------------------------------------------------------------------------------
The utf8mb4 Character Set (4-Byte UTF-8 Unicode Encoding)
http://dev.mysql.com/doc/refman/5.6/en/charset-unicode-utf8mb4.html
--------------------------------------------------------------------------------
http://www.fileformat.info/info/unicode/char/100000/index.htm
> UTF-8 (hex) 0xF4 0x80 0x80 0x80 (f4808080)
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
Try utf8mb4 (#10772#note-7).
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
related_issues
relates,Closed,19742,RedmineInstall: MySQL: collation_database
relates,Closed,31921,Changes to properly support 4 byte characters (emoji) when database is MySQL
duplicates,Closed,10779,redmine cannot deal with 4-byte utf-8 characters
duplicates,Closed,10772,4-byte utf-8 characters
duplicates,Closed,21679,Emoji [CL] will break the subject of new tickets