Re: [Full-Disclosure] Question: is this exploitable?

["Jonathan A. Zdziarski" <jonathan@nuclearelephant.com>]

Escaping quote characters might work OK in MySQL, but it is at best only
a database-dependent solution.  Take a look at Oracle, instead of
double-quotes, single-quotes are used.  And instead of being escaped,
they are simply doubled (e.g. ' becomes '').  You'd have to write an
entirely different mechanism to untaint data bound for Oracle...and
another one for other different database implementations.

This is why placeholders are a better solution.  For one, they keep you
in a database-independent environment (which makes sense, since you're
using DBI).  For another, they insure you don't have to worry about
accidentally missing the escaping of some data.

On Sat, 2003-10-18 at 22:36, Paul Tinsley wrote:
> I don't believe this is a true statement.


_______________________________________________
Full-Disclosure - We believe in it.
Charter: http://lists.netsys.com/full-disclosure-charter.html