I am happy to announce another development release of DBD::ODBC. Many
thanks to everyone who has contributed to this release and especially to
all my friends on the #dbi irc channel and perl monks. My intention is
to add a lob writing method and full support for DBI's DiscardString and
StrictlyTyped attributes in the next development release before
releasing a final development release and finally a 1.25 full release.
To support the new odbc_lob_read I've had to delay the binding of
columns until the first fetch instead of as before when the result-set
was described. This should not have any adverse effects but you are
advised to test this release as without any feedback it will move to the
next final release. The changes since the last full release are:
=head2 Changes in DBD::ODBC 1.24_2 July 23, 2010
Fix rt57957 reported by Marc Prewitt. DBD::ODBC was not ignoring named
placeholders and ? inside comments. Comments are deemed as text
between "/*" and "*/" (if not in a literal) and line comments begin
with "--".
Added a FAQ on procedures not completing in MS SQL Server. Thanks to
Peter Rabbitson for hitting this problem and reminding me I'd seen it
a couple of times before.
Added a FAQ on equality comparisons with ntext columns.
Added pod for last_insert_id which is not currently supported.
Fix bug where if SQLMoreResults was called and failed it was not
reported.
Removed some unused fields from the fbh structure which should save
a little memory for each column in a result-set.
Started adding support for DBI's DiscardString and StrictlyTyped but not
complete yet so don't use them yet.
Added experimental odbc_lob_read method - see pod. Thanks to tye and
ikegami on perlmonks for pointing out some problems with my initial
implementation.
Moved the binding of columns to the first call to fetch instead of
after execute is called as it prevents bind_col overriding the type
used for binding and I needed it to support odbc_lob_read. This may
have undesired affects so any testing of this release would be
appreciated.
Added bind_col method so DBD::ODBC can support attributes on a
bind_col call.
Removed support for DBI's blob_read - it was totally flawed and did
not work at all. May replace in the future.
Added support for MS SQL Server XML type (SQL type -152). See rt 59621.
Added note on do method implementation in DBD::ODBC and how some may
consider it to deviate from the DBI specification.
=head2 Changes in DBD::ODBC 1.24_1 May 27, 2010
Corrected pod and private attributes for the odbc_SQL_DRIVER_ODBC_VER
attribute which was documented as SQL_DRIVER_ODBC_VER.
Added FAQ on pauses on statement destruction when all the result-set
has not been retrieved (mostly freeTDS and MS SQL Server ODBC Driver).
Fixed bug introduced in 1.24 where if you are using MS SQL Server, and
you are preparing, binding placeholders and re-executing multiple
times you may get a "Invalid character value for cast specification"
error. Thanks to anonymous for spotting this and producing a
standalone example of the problem that made it so much easier to find.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
