Incorrect Text Encoding - Question | JoomShaper

Incorrect Text Encoding

Viktor

Viktor

SP Page Builder 4 days ago

Hello support, I started using SP Comments on my test site. The site language is Russian (ru-RU). After entering a comment and reloading the page, the browser displays incorrect text encoding.

Site parameter: Joomla 6.0 PHP 8.4 Mysql 8.0.34 sppagebuilder_pro_v6.3.0 helixultimate_v2.2.4

0
5 Answers
Ziaul Kabir
Ziaul Kabir
Accepted Answer
Support Agent 4 days ago #218560

Hello,

Thanks for reaching out to us. Could you please share temporary administrator access to your Joomla backend? You can provide the credentials securely in the hidden content section. Also, please take a full backup of your site before we make any changes.

Once I have access, I’ll investigate further and see what’s causing the issue. Let me know once you’ve shared the details!

Best regards,

0
Viktor
Viktor
Accepted Answer
4 days ago #218564

At your request, I am providing access to the test site.

0
Ziaul Kabir
Ziaul Kabir
Accepted Answer
Support Agent 3 days ago #218577

Hello Viktor,

Thank you for the detailed information.

We have exported your page and tested it in our local environment using the same setup (Joomla 6, PHP 8.4, MySQL 8, SP Page Builder Pro 6.3.0, Helix Ultimate 2.2.4). On our side, the comments display correctly and we are not able to reproduce the incorrect text encoding issue.

Since the problem only appears on your live site, it is most likely related to the server configuration rather than SP Page Builder or SP Comments.

Please check the following on your hosting environment:

  1. Make sure the database and all tables use utf8mb4 charset and utf8mb4_unicode_ci (or similar) collation.
  2. Confirm that the database connection collation in Joomla Global Configuration matches utf8mb4.
  3. Ensure your server is sending the correct header:

Content-Type: text/html; charset=utf-8

4.  Verify that there is no .htaccess rule overriding charset settings.
5.  Ask your hosting provider to confirm that MySQL connection encoding is set to utf8mb4.

Encoding issues like this are typically caused by a mismatch between database charset, table collation, and server output encoding.

Please review these settings and let us know the results.

Kind regards,

0
Viktor
Viktor
Accepted Answer
3 days ago #218586

I looked at the site settings:

  • Database Collation: utf8mb3_general_ci
  • Database Connection Collation: utf8mb4_0900_ai_ci

The problem appears not only on this site, but also on another server, here is an example: http://compass.beget.tech/component/content/article/vozmozhnost-zashchitit-svoyu-nedvizhimost?catid=8&Itemid=101

If I remove SP Comments from the page, the title is displayed correctly, here is a screenshot: https://disk.yandex.ru/i/JhzIzPBdtDeCzQ

You write that your comments are displayed correctly, but in what language? If it's (en-GB), then I agree. If it's (ru-RU), please provide me with a screenshot to confirm.

Sorry for my English

0
Ziaul Kabir
Ziaul Kabir
Accepted Answer
Support Agent 3 days ago #218590

I have forwarded this to our development team for further review.

Thanks

0