[freetds] A more proper workaround for this Perl DBD::ODBC workaround ....
chadjamesjohnson at gmail.com
Thu Mar 19 01:14:48 EDT 2009
On Tue, Mar 17, 2009 at 7:59 PM, Chad Johnson
<chadjamesjohnson at gmail.com> wrote:
> I think you got the gist of it! To summarize: Queries are getting
> re-prepared between executes when the size of the bound strings
> increases. To work around this the DBD::ODBC authors set a minimum
> size of 80 on bound varchar data. Additional logic exists in
> DBD::ODBC to keep track of the minimum size in between executes.
> From your previous comment it sounds like a better solution would be
> to call SQLSetStmtAttr() instead. I'll give that a shot. Thanks!
> -Chad J
I perused the ODBC docs at :
And the correct `Attribute` to pass into SQLSetStmtAttr is not jumping
out at me to increase the size of the buffer for one parameter. I
make no claims to being an ODBC guru, but, from what I can discern
these `Attributes` effect the entire statement (as the name of the
function would imply) as opposed to just one parameter on the
statement. Am I missing something obvious?
More information about the FreeTDS