You must Sign In to post a response.
  • Category: XML

    Read Xml Nodes value containing special character

    Hello

    I am consuming an API response in XML format and want to save XML nodes value within table columns. But SQL is not reading nodes containing special character like '&'. Getting XML parsing error.

    is there any way to save nodes value containing the special character in SQL.

    Thanks
  • #769856
    Hi Pankaj,

    By using nvarchar data type in sql table column. You can store most of ASCII value such as special character also.

    Regards,
    Nirav Lalan
    DNS Gold Member
    "Failure is the path of least persistence"


  • Sign In to post your comments