I have my database which contains some of the special characters (&, >, <, ") after I wrote a Google Script to display a table from my database by using deploy as Web App. The special characters as mentioned above change to & amp; & gt; & lt; & quot;
However some special characters for example $, #, @, !, ~, `, \, |, :, ;. They are displayed perfectly fine.
Could you please help?
I guess it is something to do with charsets ISO-8859 and UTF-8. But I don't know how to encode them. (https://www.w3schools.com/charsets/ref_html_8859.asp)
the script that I am working on is similar with the link provided below: https://github.com/gkaldevrel/charts-in-apps-script/blob/master/GoogleFormsVisualizer.gs
Thank you
Boon