Pyodbc

Version 4.0.38 had a serious bug in Row.__repr__ which could cause crashes (1196 ). That version has been yanked from PyPI and replaced with this one.

Version 5.0 is on its way and will drop support for Python 2. This release is a (hopefully
final) bug fix release for the 4.x line.

A big thanks to everyone involved:

- Keith Erskine did a ton of great work (as always) on the release automation.
- baluyotraf provided typing for Connection, Cursor, and connect parameters.
- Dongyoon Han corrected the install location of the pyi file.
- Michael Kleehammer fixed Unicode errors in repr(row)
- Keith fixed more typing related issues by removing TypeAlias
- arturxedex128 opened a security advisory for a buffer overflow if selecting a decimal more
than 100 digits long. Fixed by Michael Kleehammer.

Note that the 4.0.36 does not build with some versions of GCC. The 4.0.37 version is a fix for
this. Version 4.0.37 did not have the setup.py `VERSION` variable updated, so 4.0.38 is a fix for that!

This release provides Python 3.11 wheels, plus some other wheel fixes. A special thanks to keitherskine for the wheel and automated build support that makes this possible.

There is also an import memory fix when using `fast_execute_many`. Thanks to gordthompson for that.

First, I want to say thank you very, very much to the people that setup and maintained the automated building of wheels: keitherskine, hugovk, and abitrolly. This is the first release with wheels for Mac, completely thanks to them. It also saves me a huge amount of time since I no longer have to generate each wheel by hand on different systems.

Release highlights:

- Mac wheels are finally here. Thanks to all that worked on the code for that. Please let us
know if there are any problems with the wheels on PyPI
- Python 3.10 wheels are also available
- Fix for DSNs with non-ASCII characters.
- Memory leak fix with Decimal parameters.
- PostgreSQL dates of -Infinity/+Infinity changed to year 1 and 9999 instead of raising an error.

A backwards compatibility bug on Windows was causing "missing DLL" errors and not allowing pyodbc to be loaded (663). This affected Python versions 3.5+. This was due to building with a compiler that was newer than those used by the official Python builds. The newer Visual Studio 2019 introduced a dependency a new DLL which doesn't ship with Python, so pyodbc would fail to load unless something else had already installed the DLL.

Keith Erskine added a fix to check for overflow of integer and floating point parameters so that a proper Python exception is raised (671).

Kieth and Gord Thompson also provided a bunch of improvements for unit tests.

Anatoli Babenia updated the readme with a badge for PyPI which provides a quick link to it. Very nice. PyPI should now also include the contents of the readme instead of just a single sentence thanks to a commit by Keith.

Fixes in this release:

* Fix incorrect size calcation for Unicode characters (654)
* Fix binding of 32-bit ints on 64-bit Linux (611)
* Fixes type mismatch for null/None with table value parameters. 596
* Fixes and cleanup of unit tests for MS Access (606), MySQL (630 632) and new tests (637 645)

Many thanks to everyone who provided these fixes. Merry Christmas.