Encoding of special characters

[Erkan Yilmaz]

Hi everyone,

I've an issue with the encoding of special characters

 

 

It's about those annoying black diamonds with question marks: the ë's, è's and é's are no longer recognized. They are also replaced by question marks in the source code. In DB they are correct. I have changed the encoding to UTF-16 and ISO-8859-1. I have also tried with HTML and HEX codes but unfortunately to no avail. I have the impression that it is somewhere with the collation of the DB. In the meantime I have changed the collation to utf8mb64_general_ci but to no avail. In the extensions of PHP mbstring is also enabled.

This issue happens only in BO.

Has anyone any idea how to solve this issue?

With kind regards, Erkan

[Knowband Plugins]

Since you've already updated the collation to utf8mb4_general_ci, make sure that:
The encoding of your database, tables, and relevant columns is set to utf8mb4.
To ensure this, you can run these commands for each table and column with special characters:
ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
Make sure that columns containing special characters (like VARCHAR or TEXT types) are also set to utf8mb4

Make sure that columns containing special characters (like VARCHAR or TEXT types) are also set to utf8mb4
In your PHP configuration (php.ini), ensure the default charset is set to utf-8:
ini

Go to International > Localization in PrestaShop’s BO.
Ensure that the default language and localization are set to use UTF-8.