Skip Navigation

Home › Support › English Support › [Resolved] Problem with Turkish Characters

[Resolved] Problem with Turkish Characters

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

Problem:
If you're experiencing issues with Turkish characters such as 'şçöğü' displaying as '?' after using automatic translation with WPML on your site, the issue might be related to the database character set.
Solution:
We recommend checking if your database character set is set to UTF-8. You can find instructions on how to retrieve this information here.

If this solution does not apply to your case, or if it seems outdated, 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 0 replies, has 1 voice.

Last updated by Otto 2 days, 12 hours ago.

Assisted by: Otto.

Author Posts
March 25, 2025 at 6:00 pm #16859379

Otto
Supporter

Languages: English (English ) Spanish (Español )

Timezone: America/Argentina/Buenos_Aires (GMT-03:00)

Hello,

But in the title, it does work as expected, right? I double-checked, and the collations are the same.

Can you please try publishing the translation?

If it does not work, I'll need to take another copy of your site to escalate the issue to our second-tier support. Let me know if it's ok with you, please.

Best Regards,
Otto
March 26, 2025 at 8:19 am #16860908

bernaT

Hello,

I tried adding a dot to the title and tried again, but it did not call back any previous translation from memory. Also, I tried publishing, and nothing changed.

Moreover, I've attached a photo showing that the titles are also wrong.

I sent the details to enter the WordPress admin in a private message on March 12th. The ID and Password are still the same. Can you also please check if we could address the problem together, Otto?

Best

Name of the Titles.png
March 26, 2025 at 4:50 pm #16864425

Otto
Supporter

Languages: English (English ) Spanish (Español )

Timezone: America/Argentina/Buenos_Aires (GMT-03:00)

Hello,

I am sorry I missed fixing the collation for an extra table.

Now, after updating the translation, as far as I can see, it's working:
hidden link

Can you please confirm?

Best Regards,
Otto
March 27, 2025 at 9:38 am #16867148
bernaT

There are still some wrong collations; I've attached the images with arrows pointing to them to this message.

Also, why did a Turkish Course is listed on the English course search?

Best

New threads created by Otto and linked to this one are listed below:

https://wpml.org/forums/topic/turkish-course-is-listed-on-the-english-course-search/

Problem Persist on Some Parts.png
Problem Persist on Some Parts 2.png
March 27, 2025 at 12:14 pm #16868381

Otto
Supporter

Languages: English (English ) Spanish (Español )

Timezone: America/Argentina/Buenos_Aires (GMT-03:00)

Hi,

Thanks.

I changed the collation for other two tables. Can you please check again?

Regarding your new question, let's continue in this new ticket:
https://wpml.org/forums/topic/turkish-course-is-listed-on-the-english-course-search/

Best Regards,
Otto
March 29, 2025 at 1:26 pm #16875317

bernaT

I can still see a bunch of Question Marks in the top right corner. Also, at the form below as well. Can we just change all the tables?

I've installed the plugin mentioned. Both problems persist.

Best

Screenshot 2025-03-29 161906.png
Screenshot 2025-03-29 161311.png
March 31, 2025 at 12:27 pm #16879239

Otto
Supporter

Languages: English (English ) Spanish (Español )

Timezone: America/Argentina/Buenos_Aires (GMT-03:00)

Hi,

I can't do it all at once, I have an error when trying to run a query to do so:

Error
SQL query: Copy
ALTER TABLE `yaLCn_signups` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
MySQL said: Documentation
#1044 - Access denied for user 'u452833898_z0aRu'@'127.0.0.1' to database 'information_schema'

Can you please check it with your hosting? They may be able to change the collation for you directly. Make sure that it's also done for the columns.

About the other issue, I'll follow up in the other ticket.

Best Regards,
Otto
April 3, 2025 at 12:40 pm #16892195

bernaT

They mentioned that they've reset the access. Can you please check again?

Best
April 3, 2025 at 1:02 pm #16892461

bernaT

There is a non-existing Turkish course that has been listed in English courses. There is no way to delete that course. Did you add it? (I've cleared the cache and cookies. It is still there)

This is a running website, Otto. Can we please make the changes in the staging website and than publish it to the main?

We can't afford such mistakes. How can we delete the course that is not showing in the courses list? The image and link can be found below.

Best

hidden link

Screenshot 2025-04-03 155920.png
April 3, 2025 at 1:20 pm #16892587

bernaT

Alright, I was able to find it in the testing environments and deleted it. My latest message has been resolved. Thanks.

The hosting firm "Hostinger" has mentioned that they've reset the access. Would you also like to access the Hosting Panel? Can you please check again?

Best
April 3, 2025 at 2:44 pm #16893146

Otto
Supporter

Languages: English (English ) Spanish (Español )

Timezone: America/Argentina/Buenos_Aires (GMT-03:00)

Hello,

I am still having permission issues.

I changed the collation of the other tables and columns manually and had no issues. But as you requested to change them all, and then I need to do it programmatically because there are many tables with many columns (250). When running the SQL query to do so, I am not allowed.

I think it will be more efficient if the hosting support does this on their end.

Let me know if they can do it or if they fix the user privileges.

Best Regards,
Otto
April 7, 2025 at 12:48 pm #16904400

bernaT

Otto, they replied with the following message below:

"In this case, you need to download database backup: hidden link

Install PhpMyAdmin or any MYSQL workbench locally, perform an update and upload the ready database back to the hosting plan: hidden link"

Do you think we can solve this matter? I do not understand why it has taken so long and how it affects the SEO of the Website. When would we be able to solve this matter? and do we need special assistance?

Best
April 7, 2025 at 3:57 pm #16905308

bernaT

Hi Otto, I have decided to terminate my contract and ask for a refund to the WPML. Thanks for the help, you were the best.
April 7, 2025 at 4:23 pm #16905418

Otto
Supporter

Languages: English (English ) Spanish (Español )

Timezone: America/Argentina/Buenos_Aires (GMT-03:00)

Hi,

I am sorry to hear that 🙁

What your hosting suggests does not make sense. But the change can be done manually. It's much more work and outside the scope of our support, but if you change your mind, we can help you with that.

Best Regards,
Otto