Defect #26386
closed
Mysql: Unable to update ticket with Emoji
0%
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
Updated by Toshi MARUYAMA almost 7 years ago
- Status changed from New to Closed
- Resolution set to Duplicate
Updated by Toshi MARUYAMA almost 7 years ago
- Subject changed from Unable to update ticket with Emoji to Mysql: Unable to update ticket with Emoji
Updated by Marius BĂLTEANU over 4 years ago
- Related to Feature #31921: Changes to properly support 4 byte characters (emoji) when database is MySQL added