Wouldn’t that be " in xml? i.e. “hi "mom" lol” **edit: ** tested; works fine: declare @xml xml set @xml=”<transaction><item value=”hi "mom" lol” ItemId=”106″ ItemType=”2″ instanceId=”215923801″ dataSetId=”1″ /></transaction>” select @xml.value(‘(//item/@value)[1]’,’varchar(50)’)
The MySQL documentation you cite actually says a little bit more than you mention. It also says, A “’” inside a string quoted with “’” may be written as “””. (Also, you linked to the MySQL 5.0 version of Table 8.1. Special Character Escape Sequences, and the current version is 5.6 — but the current … Read more
" is on the official list of valid HTML 4 entities, but ' is not. From C.16. The Named Character Reference ‘: The named character reference ' (the apostrophe, U+0027) was introduced in XML 1.0 but does not appear in HTML. Authors should therefore use ' instead of ' to work as expected in HTML … Read more
From the SVN book (emphasis added): The perceptive reader is probably wondering at this point whether the peg revision syntax causes problems for working copy paths or URLs that actually have at signs in them. After all, how does svn know whether news@11 is the name of a directory in my tree or just a … Read more
Take your JSON and .stringify() it. Then use the .replace() method and replace all occurrences of \n with \\n. EDIT: As far as I know of, there are no well-known JS libraries for escaping all special characters in a string. But, you could chain the .replace() method and replace all of the special characters like … Read more
Use the {@literal} javadoc tag: /** * This is an “at” symbol: {@literal @} */ The javadoc for this will read: This is an “at” symbol: @ Of course, this will work for any characters, and is the “officially supported” way of displaying any “special” characters. It is also the most straighforward – you don’t … Read more
There is a problem with your solution code–it will only escape the first occurrence of each special character. For example: escapeHtml(‘Kip\’s <b>evil</b> “test” code\’s here’); Actual: Kip's <b>evil</b> "test” code’s here Expected: Kip's <b>evil</b> "test" code's here Here is code that works properly: function escapeHtml(text) { return text .replace(/&/g, “&”) .replace(/</g, “<”) .replace(/>/g, “>”) .replace(/”/g, … Read more
You should always consider what the browser will see by the end. In this case, it will see this: <img src=”https://stackoverflow.com/questions/16134910/something” onmouseover=”change(” ex1′)’ /> In other words, the “onmouseover” attribute is just change(, and there’s another “attribute” called ex1′)’ with no value. The truth is, HTML does not use \ for an escape character. But … Read more
A long time ago, I found this: private static string ToLiteral(string input) { using (var writer = new StringWriter()) { using (var provider = CodeDomProvider.CreateProvider(“CSharp”)) { provider.GenerateCodeFromExpression(new CodePrimitiveExpression(input), writer, null); return writer.ToString(); } } } This code: var input = “\tHello\r\n\tWorld!”; Console.WriteLine(input); Console.WriteLine(ToLiteral(input)); Produces: Hello World! “\tHello\r\n\tWorld!” These days, Graham discovered you can use Roslyn’s … Read more
You could use HTML entities: ' for ‘ " for ” … For more, you can take a look at Character entity references in HTML.