Defect #26386

Mysql: Unable to update ticket with Emoji

Added by Raju M about 3 years ago. Updated about 3 years ago.

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

0%

Category:-
Target version:-
Resolution:Duplicate Affected version:

Description

Getting below error while updating ticket with emoji. Please help me to resolve the issue.

Completed 500 Internal Server Error in 61ms (ActiveRecord: 16.1ms)

ActiveRecord::StatementInvalid (Mysql2::Error: Incorrect string value: '\xF0\x9F\x98\x8A' for column 'notes' at row 1: INSERT INTO `journals` (`journalized_id`, `journalized_type`, `user_id`, `notes`, `created_on`) VALUES (5068, 'Issue', 4, 'Testing with emoji ð', '2017-07-08 04:46:21')):
app/models/journal.rb:67:in `save'
app/models/issue.rb:1690:in `create_journal'
app/models/issue.rb:210:in `create_or_update'
app/controllers/issues_controller.rb:515:in `block in save_issue_with_child_records'
app/controllers/issues_controller.rb:503:in `save_issue_with_child_records'
app/controllers/issues_controller.rb:179:in `update'
lib/redmine/sudo_mode.rb:63:in `sudo_mode'


Related issues

Related to Redmine - Feature #31921: Changes to properly support 4 byte characters (emoji) whe... Closed

History

#1 Updated by Toshi MARUYAMA about 3 years ago

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

#2 Updated by Toshi MARUYAMA about 3 years ago

  • Subject changed from Unable to update ticket with Emoji to Mysql: Unable to update ticket with Emoji

#3 Updated by Marius BALTEANU 12 months ago

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

Also available in: Atom PDF