mkleehammer/pyodbc 4.0.18

Fixes

on GitHub

This is a primarily a fix patch, thought it does contain one new feature that is turned off by default:

The feature is an optimized Cursor.executemany that binds parameters into an array to drastically reduce network round trips. This can be a major speedup, but this preliminary version is turned off by default because it can only be used with drivers that use UCS-2 exclusively and that properly deal with the ODBC numeric structure. Right now I would recommend only using this with SQL Server on Windows. This feature will be tweaked in the near future to support as many drivers as possible and to use the configured encodings.

Fixes

• Add a workaround for building on macOS High Sierra.
• Add support for building with homebrew unixODBC
• Fix Unicode error messages that were sometimes garbled in the past.
• Fix Cursor.columns, primaryKeys, and similar metadata methods that would not allow None passed in for optional keyword parameters such as Cursor.columns('t1', schema=None).