Special characters in comment file displayed error

More
7 years 7 months ago #103627 by NF
Hi,

Using the Joom Donation comments field, people can put in data with special characters like é, ú etc. These are not correctly displayed as it looks like your software is not doing something like escape string or replacing before the data is stored in the database. Is there a way to fix that?

With kind regards and thanks in advance,
Nico

Please Log in or Create an account to join the conversation.

More
7 years 7 months ago #103630 by Mr. Dam
Hi Nico,
Can you please send us the screenshot of problem?
Thanks
Dam

Please Log in or Create an account to join the conversation.

More
7 years 6 months ago #103987 by NF
Hi Dam,

Sorry for my late response. First I had no live example as there was no donor with umlaut in his donation data. After I got one, I could not access www.joomdonation.com anymore because of a "Access Denied - Sucuri Website Firewall message".

But I have fixed the problem finally myself. I was doing an sqli on your data table from outside joomla in a separate called php-script and then bringing that data back in my joomla website. Adding
Code:
mysqli_set_charset($conn,"utf8");
solved my problem.

So it had nothing to do with your nice software, it was the way that I was access it.

With kind regards,
Nico

Please Log in or Create an account to join the conversation.

Moderators: Mr. DamDũng Nguyễn Việt