Incorrect text encoding - Forum | JoomShaper
Solved SP Page Builder

Incorrect text encoding

Asked by Viktor 7 months ago Last activity 6 months ago

Accepted answer

Marked as the solution
Ziaul Kabir Staff

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

Thanks

5 more replies

Ziaul Kabir Staff

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,

Viktor Asked this

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

Ziaul Kabir Staff

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,

Viktor Asked this

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

Viktor Asked this

The issue has been resolved with the SP Page Builder 3.6.1 update, thank you!

Ziaul Kabir Staff

You are welcome.

Log in to reply.