Defect #18866
MySQL: disappear after 4-Byte UTF-8
Status: | New | Start date: | ||
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | - | % Done: | 0% | |
Category: | Database | |||
Target version: | - | |||
Resolution: | Affected version: | 2.5.2 |
Description
When writing tasks text after some characters disappear. For example, after the symbol «
Related issues
History
#1
Updated by Алексей Городецкий about 8 years ago
@When writing tasks text after some characters disappear. For example, after the symbol «
#2
Updated by Toshi MARUYAMA about 8 years ago
after the symbol « after the symbol « after the symbol «
#3
Updated by Toshi MARUYAMA about 8 years ago
- File issue.png added
- Status changed from New to Needs feedback
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
#4
Updated by Имя Фамилия about 8 years ago
For example, after the symbol "". This symbol was been encoded for this message as
􀀀. Copy this message to reproduce.
#5
Updated by Имя Фамилия about 8 years ago
Copy:
For example, after the symbol "
#6
Updated by Toshi MARUYAMA about 8 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
#7
Updated by Toshi MARUYAMA about 8 years ago
http://www.fileformat.info/info/unicode/char/100000/index.htm
UTF-8 (hex) 0xF4 0x80 0x80 0x80 (f4808080)
#8
Updated by Toshi MARUYAMA about 8 years ago
- Subject changed from When writing tasks text disappears after some characters to MySQL: disappear after 4-Byte UTF-8
#9
Updated by Toshi MARUYAMA over 7 years ago
- Related to Patch #19742: RedmineInstall: MySQL: collation_database added
#10
Updated by Toshi MARUYAMA over 7 years ago
- Status changed from New to Closed
- Resolution set to Duplicate
#11
Updated by Toshi MARUYAMA over 7 years ago
- Duplicates Defect #10772: 4-byte utf-8 characters added
#12
Updated by Toshi MARUYAMA over 7 years ago
- Related to deleted (Patch #19742: RedmineInstall: MySQL: collation_database)
#13
Updated by Toshi MARUYAMA over 7 years ago
- Status changed from Closed to New
- Resolution deleted (
Duplicate)
#14
Updated by Toshi MARUYAMA over 7 years ago
- Related to Patch #19742: RedmineInstall: MySQL: collation_database added
#15
Updated by Toshi MARUYAMA over 7 years ago
Try utf8mb4 (#10772#note-7).
#16
Updated by Toshi MARUYAMA over 7 years ago
- Duplicated by Defect #10779: redmine cannot deal with 4-byte utf-8 characters added
#17
Updated by Toshi MARUYAMA over 7 years ago
- Status changed from New to Closed
#18
Updated by Toshi MARUYAMA over 7 years ago
- Status changed from Closed to New
#19
Updated by Toshi MARUYAMA over 7 years ago
- Duplicated by deleted (Defect #10779: redmine cannot deal with 4-byte utf-8 characters)
#20
Updated by Toshi MARUYAMA over 7 years ago
- Duplicates deleted (Defect #10772: 4-byte utf-8 characters)
#21
Updated by Toshi MARUYAMA over 7 years ago
- Duplicated by Defect #10779: redmine cannot deal with 4-byte utf-8 characters added
#22
Updated by Toshi MARUYAMA over 7 years ago
- Duplicated by Defect #10772: 4-byte utf-8 characters added
#23
Updated by Toshi MARUYAMA about 7 years ago
- Duplicated by Defect #21679: Emoji [CL] will break the subject of new tickets added
#24
Updated by Marius BALTEANU over 3 years ago
- Related to Feature #31921: Changes to properly support 4 byte characters (emoji) when database is MySQL added