Defect #30848

Error when creating issue with emoji in description

Added by Jamal Aziz about 3 years ago. Updated over 1 year ago.

Status:NewStart date:
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Issues
Target version:-
Resolution: Affected version:4.0.1

Description

When creating issue with emoji in description, it will return error. Here is the log:

[[Completed 500 Internal Server Error in 54ms (ActiveRecord: 12.9ms)

ActiveRecord::StatementInvalid (Mysql2::Error: Incorrect string value: '\xF0\x9F\x98\x84\xF0\x9F...' for column 'description' at row 1:
INSERT INTO `issues` (`tracker_id`, `project_id`, `subject`, `description`, `status_id`, `priority_id`, `author_id`, `created_on`, `upda
ted_on`, `start_date`, `lock_version`) VALUES (14, 111, 'Tes Emoji', 'Test <U+1F604><U+1F604><U+1F604>', 1
, 2, 39, '2019-02-20 13:39:02', '2019-02-20 13:39:02', '2019-02-20', 0)):
]]

Related issues

Related to Redmine - Feature #31921: Changes to properly support 4 byte characters (emoji) whe... Closed
Related to Redmine - Defect #35879: mail handler failing when smilies inline Closed

History

#1 Updated by Marius BALTEANU almost 3 years ago

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

#2 Updated by Erik Moeller over 1 year ago

We can reproduce this on our Redmine 4.0.7 setup, with an emoji in the title of the issue.

#3 Updated by Mischa The Evil 8 months ago

  • Related to Defect #35879: mail handler failing when smilies inline added

Also available in: Atom PDF