On Sat, Oct 26, 2002 at 12:22:14PM -0700, David Wheeler wrote: > > Now, the driver-development questions: Should DBD::Pg's execute() > method know which bound parameters are binary without being explicitly > told via the attributes to bind_param(), and escape accordingly? Or > should DBI users always explicitly bind binary data using > bind_param()'s attributes? > > If the answer to the first question is "yes", then how should this be > implemented? And if the answer to the first question is "no" and the > second question is "maybe", would it make sense to have whatever code > in execute() that is escaping string data also do the proper escapes > for binary data, since in PostgreSQL they're compatible?
A goal of the DBI is to make things simple. If some form of escaping works for binary and non-binary data then it would seem to make most sense to use that. Are there any downsides? Tim.
