Skip Navigation

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 2 replies, has 3 voices.

Last updated by Marcel 1 year, 4 months ago.

Assisted by: Prosenjit Barman.

Author Posts
September 21, 2023 at 3:22 pm #14440733

michaelm-30

I am trying to: translate with "advanced" translation editor

Link to a page where the issue can be seen: hidden link

I expected to see: i input a text in DE with umlauts f.e. "für alle deine Räder"

Instead, I got: für alle deine Räder

September 22, 2023 at 9:35 am #14445667

Prosenjit Barman
Supporter

Languages: English (English )

Timezone: Asia/Dhaka (GMT+06:00)

Hello There,
Thanks for contacting WPML Support.

I understand the issue you're having and will try my best to assist you in this matter.

The issue you're having with the German characters most of the time happens due to not setting up the database collation correctly. From the WPML debug info, I can see that the Database collation is currently set to "utf8mb4_unicode_520_ci".

Would you please check by changing the collation to "utf8mb4_unicode_ci" and defining the charset to "utf8mb4"?

[ utf8mb4_unicode_ci is based on the official Unicode rules for universal sorting and comparison, which sorts accurately in a wide range of languages. ]

1) Open the wp-config.php file of your site root folder for editing and make sure that the following code is defined.

define( 'DB_CHARSET', 'utf8mb4' );

2) Please log in to the database using a tool like PHPMyAdmin and make sure that the collation for the database(including the Tables) is set to "utf8mb4_unicode_ci". You can reach out to the hosting support to verify if the Collation is configured correctly.

After updating the collation and charset, please retranslate the page and check if the umlauts characters are showing properly or not.

Let me know the update. I will be happy to help if you need further assistance in this matter.

Best Regards,
Prosenjit

September 22, 2023 at 3:44 pm #14447771

Marcel
Supporter

Languages: English (English ) German (Deutsch )

Timezone: Europe/Madrid (GMT+01:00)

Hello,

the issue has been fixed. You can now create a new translation job for it, then it will work.

Kind regards
Marcel