Project

General

Profile

Actions

Defect #27361

closed

Failed when using Emoji

Added by Charles So over 6 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Duplicate
Affected version:

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', '-


Files


Related issues

Related to Redmine - Feature #31921: Changes to properly support 4 byte characters (emoji) when database is MySQLClosedGo MAEDA

Actions
Is duplicate of Redmine - Defect #24992: MailHandler: an unexpected error occurred when receiving email: invalid byte sequence in UTF-8Needs feedback

Actions
Actions #1

Updated by Charles So over 6 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.

Actions #2

Updated by Charles So over 6 years ago

Here is a screen capture of the Production.log

Actions #3

Updated by Toshi MARUYAMA over 6 years ago

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

Duplicate of #24992.

Actions #4

Updated by Toshi MARUYAMA over 6 years ago

  • Is duplicate of Defect #24992: MailHandler: an unexpected error occurred when receiving email: invalid byte sequence in UTF-8 added
Actions #6

Updated by Tobias Fischer over 4 years ago

Related issue in Git commits: #24030

Actions #7

Updated by Tobias Fischer over 4 years ago

Related with more discussion: #18866 and #21398

Actions #8

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
Actions

Also available in: Atom PDF