Remove extra ASCII symbol rendering in PDF

Question

I have a user that is storing a 'registered trademark' symbol in her name in our database and when we retrieve it when the database it renders correctly, but when we actually place it onto the website itself in HTML it renders with an extra 'A' symbol in front of it:

You can see above the database value compared to what is rendered in the PDF file. I can access the database value in the backend and edit it through vb code but I am really not sure how or what the code would be to do that as I don't want to remove all ASCII characters just the extra symbol being generated and rendered in the PDF.

Any idea how to do this would be great.

Answer 1

I think the Main-Problem is that you generate wrong HTML-Code by just inserting your Database-Result-Strings into your Website

You can encode your Database String to HTML by using the HtmlEncode-Function from HttpUtility in .NET

Here is an Example from vb.net

myEncodedString = HttpUtility.HtmlEncode(myString)

If you use "myEncodedString" inside your WebPage you'll get no additional Characters and a valid HTML-Code.