How do I search for names with apostrophe in SQL Server?
Double them to escape; SELECT * FROM Header WHERE userID LIKE ‘%”%’
Double them to escape; SELECT * FROM Header WHERE userID LIKE ‘%”%’
When you quote a collection with ‘, the symbol-name will be quoted exactly as you enter it. ‘(+ x x) => (+ x x) (map namespace *1) => (nil nil nil) ‘(bingo/+ lara/y user/z) => (bingo/+ lara/y user/z) (map namespace *1) => (“bingo” “lara” “user”) When you quote a collection with the backtick, it tries … Read more
It’s HTML character references for encoding a character by its decimal code point Look at the ASCII table here and you’ll see that 39 (hex 0x27, octal 47) is the code for apostrophe
I don’t think that one is better than the other in general; it depends on how you intend to use it. If you want to store it in a DB column that has a charset/collation that does not support the right single quote character, you may run into storing it as the multi-byte character instead … Read more
It’s certainly valid to use single quotes (HTML 4.01, section 3.2.2). I haven’t noticed such a trend, but perhaps there’s some framework that powers web sites you’ve visited that happens to quote using single quotes.