Font Problem in Backend and Frontend

[hanisnl]

Hello there .

I have this weird problem .
The website that I'm editing is using Prestashop 1.6.1.6 with a plugin called CS Blog for posting articles.

The problem is : after posting an article, the text with Special Characters are replaced by Question Marks .

First I thought that this was a font problem .

Now I'm 100% sure that the font used is ok for Special Characters because it's the same font as the title, and the title does NOT loose the special characters .

 

So now, when posting .. the title stays the same, the special characters are there, but the main text gets scrambled and the special characters get replaced by Question Marks .

 

to be clear, the text is changed after posting, but only for the main text - the title is ok, and it's not a display problem in the front-end. the text is changed in the back-end .

 

Can anyone tell me how do I fix this ?

[hanisnl]

I think I found the issue .. it's a databse problem ... I'll test this and come back with the fix .. maybe someone else has the same problem .

[hanisnl]

So, I found that this blog module was using MyISAM instead of Innodb and the char set was not utf8mb_general_ci .

I converted those tables AND also the columns from PhpMyAdmin and now it all works great !