Defect #18866
closed
MySQL: disappear after 4-Byte UTF-8
Added by Алексей Городецкий almost 10 years ago. Updated about 1 year ago.
0%
Description
When writing tasks text after some characters disappear. For example, after the symbol «
Files
Related issues
Updated by Алексей Городецкий almost 10 years ago
林 业文 writing tasks text after some characters disappear. For example, after the symbol «
Updated by Toshi MARUYAMA almost 10 years ago
after the symbol « after the symbol « after the symbol «
Updated by Toshi MARUYAMA almost 10 years ago
I cannot reproduce.
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
Updated by Имя Фамилия almost 10 years ago
For example, after the symbol "". This symbol was been encoded for this message as
􀀀. Copy this message to reproduce.
Updated by Toshi MARUYAMA almost 10 years ago
- Category changed from Issues to Database
- Status changed from Needs feedback to New
The utf8mb4 Character Set (4-Byte UTF-8 Unicode Encoding)
http://dev.mysql.com/doc/refman/5.6/en/charset-unicode-utf8mb4.html
Updated by Toshi MARUYAMA almost 10 years ago
http://www.fileformat.info/info/unicode/char/100000/index.htm
UTF-8 (hex) 0xF4 0x80 0x80 0x80 (f4808080)
Updated by Toshi MARUYAMA almost 10 years ago
- Subject changed from When writing tasks text disappears after some characters to MySQL: disappear after 4-Byte UTF-8
Updated by Toshi MARUYAMA over 9 years ago
- Related to Patch #19742: RedmineInstall: MySQL: collation_database added
Updated by Toshi MARUYAMA over 9 years ago
- Status changed from New to Closed
- Resolution set to Duplicate
Updated by Toshi MARUYAMA over 9 years ago
- Is duplicate of Defect #10772: 4-byte utf-8 characters added
Updated by Toshi MARUYAMA over 9 years ago
- Related to deleted (Patch #19742: RedmineInstall: MySQL: collation_database)
Updated by Toshi MARUYAMA over 9 years ago
- Status changed from Closed to New
- Resolution deleted (
Duplicate)
Updated by Toshi MARUYAMA over 9 years ago
- Related to Patch #19742: RedmineInstall: MySQL: collation_database added
Updated by Toshi MARUYAMA over 9 years ago
- Has duplicate Defect #10779: redmine cannot deal with 4-byte utf-8 characters added
Updated by Toshi MARUYAMA over 9 years ago
- Has duplicate deleted (Defect #10779: redmine cannot deal with 4-byte utf-8 characters)
Updated by Toshi MARUYAMA over 9 years ago
- Is duplicate of deleted (Defect #10772: 4-byte utf-8 characters)
Updated by Toshi MARUYAMA over 9 years ago
- Has duplicate Defect #10779: redmine cannot deal with 4-byte utf-8 characters added
Updated by Toshi MARUYAMA over 9 years ago
- Has duplicate Defect #10772: 4-byte utf-8 characters added
Updated by Toshi MARUYAMA almost 9 years ago
- Has duplicate Defect #21679: Emoji [CL] will break the subject of new tickets added
Updated by Marius BĂLTEANU over 5 years ago
- Related to Feature #31921: Changes to properly support 4 byte characters (emoji) when database is MySQL added
Updated by Marius BĂLTEANU about 1 year ago
- Status changed from New to Closed
- Resolution set to Duplicate
Issues #31921, #32140 and HowTo_convert_a_database_from_utf8_to_utf8mb4 page contain enough information to identify the issues caused by utf8 and to migrate the database to utf8mb4.
Closing this as duplicate.