I'm downloading a text file from the web and immediately turning it into an xml document using an xmltextwriter. From there it is sent to a stored procedure where the file info is loaded into an SQL Server table. However, in order to test my XML document creation I am writing the XML document to a folder rather than passing it immediately to a stored procedure. In looking at the file I noticed that the characters "�" are randomly placed throughout the document, causing the info contained therein to be misformatted. I am using utf-8 encoding. I have seen references on the web that this is a null. How do I get rid of this mysterious character?
Any help would be appreciated.
Any help would be appreciated.