Defect #27361
Failed when using Emoji
| Status: | Closed | Start date: | ||
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: | - | % Done: | 0% | |
| Category: | Database | |||
| Target version: | - | |||
| Resolution: | Duplicate | Affected version: | 3.0.4 |
Description
Tried to create Issue directly or via email with emoji, reply to forum via email using emoji, and all failed.
Here is output from Production.log
ActiveRecord::StatementInvalid (Mysql2::Error: Incorrect string value: '\xF0\x9F\x87\xA6\xF0\x9F...' for column 'description' at row 1: INSERT INTO `issues` (`project_id`, `author_id`, `priority_id`, `tracker_id`, `status_id`, `subject`, `description`, `start_date`, `updated_on`, `created_on`, `lock_version`) VALUES (33, 4, 4, 2, 1, 'CCCCC list', '-
Related issues
History
#1
Updated by Charles So about 3 years ago
The error log above originally contains a few emojis.... and the whole string got cut off immediately at where the 1st emoji is.
#2
Updated by Charles So about 3 years ago
- File Screen Shot 2017-11-02 at 11.40.11 AM.jpg added
Here is a screen capture of the Production.log
#3
Updated by Toshi MARUYAMA about 3 years ago
- Status changed from New to Closed
- Resolution set to Duplicate
Duplicate of #24992.
#4
Updated by Toshi MARUYAMA about 3 years ago
- Duplicates Defect #24992: MailHandler: an unexpected error occurred when receiving email: invalid byte sequence in UTF-8 added
#5
Updated by Tobias Fischer almost 3 years ago
#6
Updated by Tobias Fischer over 1 year ago
Related issue in Git commits: #24030
#7
Updated by Tobias Fischer over 1 year ago
#8
Updated by Marius BALTEANU over 1 year ago
- Related to Feature #31921: Changes to properly support 4 byte characters (emoji) when database is MySQL added