On 20.12.2014 15:38, Tim Bunce wrote:
> [...]
> Can you, or anyone else, think of any situation where a backslash before
> a ? or :foo (or even $1) style placeholder might be valid SQL?
Inside quoted text: of course, yes.
Outside quoted text: maybe some RDBMS accept a backslash as a valid character
in the name of a table or column? (Haven't tried this out yet.)
At least make sure "\?" will not be handled as placeholder inside column name
quoting, as in e.g.
"foo \? bar"
or in
[foo \? bar]
with SQL Server, or
`foo \? bar`
for MySQL.
But my fear is that even
foo\?bar
would be accepted as valid column or table name by some RDBMS...
-- Peter Vanroose,
ABIS Training & Consulting
Leuven, Belgium.
