XML has single and double quotes, need to escape both in one

Question

I have a XML line that looks like this:

<test>
   <title name='AND error-based (BIGINT)'/>
   <payload start='AND (SELECT 2*(IF((SELECT * FROM (SELECT CONCAT('"[rand_string]"', ("[query]"), '"[rand_string]"','x'))s), "[big_int_1]", "[big_int_2]"'/>
</test>

This isn't working because the string contains both ' and ". How can I escape the quote in the middle of the string to make this valid XML?

Possible duplicate of [How to escape double quotes in XML attributes values?](https://stackoverflow.com/questions/3961505/how-to-escape-double-quotes-in-xml-attributes-values) — Quentin, Jun 02 '17 at 20:21

score 0 · Accepted Answer · answered Jun 02 '17 at 20:20

0

You can escape quotation mark as " or ", and you can escape apostrophe as '.

answered Jun 02 '17 at 20:20

Michael Kay

156,231
11
92
164

Yes it will work. I tend to avoid it because it's predefined in XML but not in HTML, but I can never remember which... – Michael Kay Jun 05 '17 at 10:32
Thank you, much appreciated, idk anything about xml and decided to learn lol – user8049647 Jun 05 '17 at 11:24

XML has single and double quotes, need to escape both in one

1 Answers1