Skip Navigation

This thread is resolved. Here is a description of the problem and solution.

Problem:
The client was facing an issue with the Advanced Translation Editor (ATE) where certain items on their menu page were not being translated correctly, specifically those containing emojis. Initially, replacing emojis with text seemed to resolve the issue, but the client wanted a solution that allowed the use of emojis.
Solution:
We investigated the issue and found that it was related to the database collation settings. The database was using the

utf8_general_ci

collation, which does not fully support emojis as they require 4 bytes per character. We recommended changing the database collation to utf8mb4_unicode_ci or utf8mb4_general_ci to properly support emojis. After the client converted their database to

utf8mb4_unicode_ci

, the issue was resolved, and emojis were displayed correctly in translations.

If you're experiencing a similar issue, we recommend checking your database collation and updating it to utf8mb4_unicode_ci to ensure full support for emojis. However, this solution might be irrelevant if it's outdated or not applicable to your case. If the issue persists, please open a new support ticket. We also highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins.

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Tagged: 

This topic contains 14 replies, has 2 voices.

Last updated by Bobby 10 months, 3 weeks ago.

Assisted by: Bobby.

Author Posts
February 7, 2024 at 7:15 pm #15278690

Bobby
Supporter

Languages: English (English )

Timezone: America/Los_Angeles (GMT-08:00)

Understand, update me here when ready.

Thank you

February 9, 2024 at 11:47 am #15285825

John-Pierre Cornelissen

Hi Bobby,

After converting the database to utf8mb4_unicode_ci it all works as expected again. Thank you for all your help and pointing me to the database collation.

Have a nice weekend.
JP