Search code examples
c#sql-serverxmlspecial-characterssqlxml

Special Charcter Issue in XML Creation using SQLXMLBULKLOADLib - C#

I am trying to load csv file using SQLXMLBULKLOADLib which first converts csv to xml and then maps it to database model. My cvs file contains special character. When SQLXMLBULKLOADLib loads it in XML, the special characters are converted to different representation like , ,  etc. I am not aware of what , ,  is. How to handle this in XML and SQL Server? I need to show the exact special character available in csv file.

Solution

  • I got answer from http://social.msdn.microsoft.com/Forums/en-au/sqlxml/thread/5c46314d-ec4c-4ec2-91c9-7ceb466af3c6