Can't save emoji in custom product options

[archonkulis]

Preconditions

1. Magento version 2.1.6 ( it doesn't matter actually )
2. PHP 7.0

3. Mysql 5.6

Steps to reproduce

1. Add some custom options to product ( text )
2. Go to product in front-end, input some emoji in that text field, e.g. "123 😍"
3. Add to cart

Expected result

1. Either cart would render fine or show an error that specific emoji insertion is not supported

Actual result

1. The cart is empty -> https://prnt.sc/h6v033

My observations

The issues seem to be because Magento uses utf8_general_ci collation for the tables and also connection. If I try to manually insert "123 😍" in the utf8_general_ci table in the database, it doesn't allow it and shows following error:

[HY000][1366] Incorrect string value: '\xF0\x9F\x98\x8D' for column 'value' at row 1

Everything would be good if Magento wouldn't serialize ( or json_encode in the newest version ) the custom_options. ( well, not good anyway, but at least the cart would render fine, just the options would be truncated )

For example, when Magento inserts the "123 😍" in the quote_item_option.vale table, it becomes:

a:5:{i:0;s:8:"123

As you can see, the string is corrupted at the end ( it truncates the string at the place where the emoji is )

I think that even if you do not plan to switch from utf8_general_ci to some other encoding which could solve this problem, you should still try to either show an error message in the front-end for the user or at least silently remove that emoji so that at least the cart would render fine.

Let me know what you think.

Thanks.

[magento-engcom-team]

@archonkulis, thank you for your report.
We've created internal ticket(s) MAGETWO-83334 to track progress on the issue.

[KarlDeux]

Got this! (think so)

[KarlDeux]

Fixed on #12253

[okorshenko]

The issue has been fixed and delivered to 2.2-develop branch. Will be available with upcoming patch release

[magento-engcom-team]

Hi @archonkulis. Thank you for your report.
The issue has been fixed in magento-engcom/magento2ce#1296 by @magento-engcom-team in 2.3-develop branch
Related commit(s):

• aefd089
• 0c799d2
• 0a28295
• d0d8d03
• 1623007
• 64f63b3
• eceb5eb
• e1db353
• 7b12d50
• 60285c4
• 2d910df
• 57c355a
• 4f9f40e
• ebd663b
• bdb62bb
• 76f6eed
• cd5c72e
• b035660
• 6217c00
• e07d040
• 47ea318

The fix will be available with the upcoming patch release.