Re: A more proper workaround for this Perl DBD::ODBC workaround ....
Chad Johnson <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
On Tue, Mar 17, 2009 at 5:37 PM, James K. Lowden <[email protected]> wrote: > I'm not sure what you're referring to. You pointed to a line in a > file, but what feature are you talking about? > > To rebind a parameter buffer to a different length, SQLSetStmtAttr() is > your friend. > > --jkl 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 _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds