WARNING: This version is experimental and adds the ability to have DBD::ODBC use
SQLDescribeParam to obtain the parameter type of the binding. Please use the
odbc_default_bind_type private attribue to activate this behavior.
Experimental release of DBD::ODBC has just been sent to CPAN.
Currently the default value of odbc_default_bind_type = SQL_VARCHAR (current behavior)
If you set odbc_default_bind_type to 0, then SQLDescribeParam will be called to
determine the columen type. Not ALL databases handle this correctly. For example,
Oracle returns SQL_VARCHAR for all types and attempts to convert to the correct type
for us. However, if you use the ODBC escaped date/time format such as: {ts
'1998-05-13 00:01:00'} then Oracle complains. If you bind this with a SQL_TIMESTAMP
type, however, Oracle's ODBC driver will parse the time/date correctly. Use at your
own risk!
The uploaded file
DBD-ODBC-0.33_01.tar.gz
has entered CPAN as
file: $CPAN/authors/id/J/JU/JURL/DBD-ODBC-0.33_01.tar.gz
size: 220480 bytes
md5: 68d0104bc167be5c35cc16d62cdb68e9
No action is required on your part
Request entered by: JURL (Jeff Urlwin)
Request entered on: Wed, 30 Jan 2002 16:37:31 GMT
Request completed: Wed, 30 Jan 2002 16:38:19 GMT
Virtually Yours,
Id: paused,v 1.74 2001/05/20 14:59:52 k Exp k