magento / magento2

Prior to making any Submission(s), you must sign an Adobe Contributor License Agreement, available here at: https://opensource.adobe.com/cla.html. All Submissions you make to Adobe Inc. and its affiliates, assigns and subsidiaries (collectively “Adobe”) are subject to the terms of the Adobe Contributor License Agreement.
http://www.magento.com
Open Software License 3.0
11.57k stars 9.32k forks source link

Enable EMOJI compatibility for Configuration: Set default collation of field "value" in table "core_config_data" to utf8mb4_unicode_ci #39393

Open vbidou opened 4 days ago

vbidou commented 4 days ago

Description

Enable Emoji compatibility for values recorded inside the Table "core_config_data". Current default collation for field "value" is utf8mb3_general_ci This collation doesn't allow full EMOJI compatibility This is possible to change the collation manually, but this change is lost during the next setup:upgrade due to the default DB schema of Magento.

Expected behavior

Allow full EMOJI compatibility by assigning default collation utf8mb4_unicode_ci to this field.

Benefits

Allow to use the full spectrum of EMOJI for the users.

Additional information

No additional information

Release note

No response

m2-assistant[bot] commented 4 days ago

Hi @vbidou. Thank you for your report. To speed up processing of this issue, make sure that the issue is reproducible on the vanilla Magento instance following Steps to reproduce.

hostep commented 3 days ago

A fix got merged a few weeks ago: https://github.com/magento/magento2/pull/35174 + changes from AC-9755 (see this merge commit with everything, I think)

This will be released in Magento 2.4.8, in April 2025