why &gt &lt being added instead of > < symobles in xml node text?

Question

User-1623675128 posted

Hi, i have a string whic h has query which in turn has < > sybmols (sql query)

in code I am creating a xml document with one element <sql>pass here the string that we have above<sql>;

the moment we add the sql stirng into XML node the symboles <> replaced by &gt &lt.

 

how to avoid this?

Answer 1

User753101303 posted

Hi,

This is correct. It's just not possible to keep < or > characters unchanged as it would ambiguous with <> as used in XML tags. So they are encoded this way.

Do you see a real issue with this ? If for example it makes some code that reads this to fail, this is this reader that is badly written and would need to be fixed.

 

Answer 2

User-1623675128 posted

the problem was with date filed which is not closed porperly with quotes; its not an issue with < >symobls in the query.

sorry...