When XML processes SQL statements, it processes the transformation of less than and greater than signs

QWERTYU · Posted on 11/9/2017 11:06:51 AM

When we need to process SQL statements through XML format, we often use symbols such as <, <=, >, >=, etc., but it is easy to cause errors in XML format, which will cause errors when converting XML strings to XML documents in the background, resulting in program errors.

Such problems often need to be dealt with in iBatiS or in custom xml processing programs. It's simple, we can avoid the above errors by making the following substitutions:

Original symbol	<	<=	>	>=	&	'	"
Replace the symbol	<	<=	>	>=	&	'	"

Little scum · Posted on 11/9/2017 11:58:47 AM

I have encountered this problem, it turns out that I wrote the sql statement into the web.config, and then it reported an error, and the special symbol needs to be escaped

[Source] When XML processes SQL statements, it processes the transformation of less than and greater than signs

Sections viewed