question mark instead of persian characters in back-office tables

[Ramin.Esl]

Hi everyone

in my back-office tables (such as categories in catalog menu), when I use Persian language for name and description, bunch of question marks are shown in table. but if I continue and click on any field to edit it, true characters are shown there.

any idea what caused this problem and how to fix it?

[sandeeptech]

 I believe this is a problem with MySQL server encoding. Can you check whether table ps_category_lang column description encoding is set to utf8mb4  or mbstring extension is already installed on your server ?

 

[Ramin.Esl]

@sandeeptech thanks for your participation.

as you can see in attached pictures, in table ps_category_lang the collation is set to "utf8mb4_general_ci" and also the mbstring extension is installed on my server.

[Ramin.Esl]

somehow I think I could find the solution for this problem! I installed the "nd_pdo_mysql" extension (instead of pdo_mysql) for PHP and the problem was fixed!

[sandeeptech]

That's great 👍