Issue with generating BI publisher report due to special characters in XML file
We have a custom application where user can make entries in several long edit boxes. This information is converted into XML using peoplecode and a PDF report is generated. We are noticing that in some instances the report is not being generated. This is due to user possibly copying text from word document and pasting into the text area. During this process, some of the characters are saved as non-Unicode characters. This in turn is causing the XML parsing to fail when trying to generate XML publisher report.
To address this, I am using regex pattern([^\x00-x7f]) to strip non-Unicode characters. However, this does not cover all the scenarios. I wanted to know if there is an efficient way of doing this? Has anyone encountered similar scenario and how was this handled?