You must Sign In to post a response.

Category: XML

23 Nov 2018 21:29

Joined:	21/07/2010
Level:	Bronze
Points:	27

Points:	2

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

28 Mar 2019 10:31

Joined:	06/04/2012
Level:	Gold
Points:	4230

Points:	2

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
"If you can dream it, you can do it."

Submit New Thread

Return to Return to Discussion Forum

Read Xml Nodes value containing special character

About dotnetspider.com

Quick Links

General

Services