The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

Changes for version 1.46_1

  • CHANGE IN BEHAVIOUR
    • As warned in release 1.45, the binding of unicode parameters to char/varchar columns has changed significantly - see warning at start of DBD::ODBC pod. If you don't attempt to insert unicode into char/varchar columns or if you only inserted unicode into nchar/nvarchar columns you should see no difference.
    • Previously if DBD::ODBC received an error or (SQL_SUCCESS_WITH_INFO) from an ODBC API call and then the driver refused to return the error state/text DBD::ODBC would issue its own error saying "Unable to fetch information about the error" and state IM008. That state was wrong and has been changed to HY000.
  • BUG FIXES
    • Some drivers cannot support catalogs and/or schema names in SQLTables. Recent changes set the schema/catalog name to the empty string (good reasons below) which causes "optional feature not implemented" from MS Access (which does not support schemas - even for a simply ping (which uses SQLTables)). Now we call SQLCATALOG_NAME and SQLSCHEMA_USAGE on connect to ascertain support which modifies SQLTables call.
  • MISCELLANEOUS
    • Added test 45_unicode_varchar.t for MS SQL Server only so far.

Documentation

Things to do in DBD::ODBC

Modules

ODBC Driver for DBI

Provides

in ODBC.pm
in ODBC.pm
in ODBC.pm

Examples