Defect #18866

MySQL: disappear after 4-Byte UTF-8

Added by Алексей Городецкий over 7 years ago. Updated almost 7 years ago.

Status:NewStart date:
Priority:NormalDue 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 «

issue.png (29.5 KB) Toshi MARUYAMA, 2015-01-16 14:29

Related issues

Related to Redmine - Patch #19742: RedmineInstall: MySQL: collation_database Closed
Related to Redmine - Feature #31921: Changes to properly support 4 byte characters (emoji) whe... Closed
Duplicated by Redmine - Defect #10779: redmine cannot deal with 4-byte utf-8 characters Closed
Duplicated by Redmine - Defect #10772: 4-byte utf-8 characters Closed
Duplicated by Redmine - Defect #21679: Emoji [CL] will break the subject of new tickets Closed

History

#1 Updated by Алексей Городецкий over 7 years ago

@When writing tasks text after some characters disappear. For example, after the symbol «

#2 Updated by Toshi MARUYAMA over 7 years ago

after the symbol « after the symbol « after the symbol «

#3 Updated by Toshi MARUYAMA over 7 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 Имя Фамилия over 7 years ago

For example, after the symbol "􀀀". This symbol was been encoded for this message as 

􀀀
. Copy this message to reproduce.

#5 Updated by Имя Фамилия over 7 years ago

Copy:
For example, after the symbol "

#6 Updated by Toshi MARUYAMA over 7 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 over 7 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 over 7 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 about 7 years ago

  • Related to Patch #19742: RedmineInstall: MySQL: collation_database added

#10 Updated by Toshi MARUYAMA almost 7 years ago

  • Status changed from New to Closed
  • Resolution set to Duplicate

#11 Updated by Toshi MARUYAMA almost 7 years ago

#12 Updated by Toshi MARUYAMA almost 7 years ago

  • Related to deleted (Patch #19742: RedmineInstall: MySQL: collation_database)

#13 Updated by Toshi MARUYAMA almost 7 years ago

  • Status changed from Closed to New
  • Resolution deleted (Duplicate)

#14 Updated by Toshi MARUYAMA almost 7 years ago

  • Related to Patch #19742: RedmineInstall: MySQL: collation_database added

#15 Updated by Toshi MARUYAMA almost 7 years ago

Try utf8mb4 (#10772#note-7).

#16 Updated by Toshi MARUYAMA almost 7 years ago

  • Duplicated by Defect #10779: redmine cannot deal with 4-byte utf-8 characters added

#17 Updated by Toshi MARUYAMA almost 7 years ago

  • Status changed from New to Closed

#18 Updated by Toshi MARUYAMA almost 7 years ago

  • Status changed from Closed to New

#19 Updated by Toshi MARUYAMA almost 7 years ago

  • Duplicated by deleted (Defect #10779: redmine cannot deal with 4-byte utf-8 characters)

#20 Updated by Toshi MARUYAMA almost 7 years ago

#21 Updated by Toshi MARUYAMA almost 7 years ago

  • Duplicated by Defect #10779: redmine cannot deal with 4-byte utf-8 characters added

#22 Updated by Toshi MARUYAMA almost 7 years ago

#23 Updated by Toshi MARUYAMA over 6 years ago

  • Duplicated by Defect #21679: Emoji [CL] will break the subject of new tickets added

#24 Updated by Marius BALTEANU over 2 years ago

  • Related to Feature #31921: Changes to properly support 4 byte characters (emoji) when database is MySQL added

Also available in: Atom PDF