pyodbc
pyodbc copied to clipboard
Python ODBC bridge
Global converters can already be configured by SQL type, but sometimes it might be useful to have a per-column setting. For example, a single column might be encrypted or compressed....
SQL `INTERVAL` types are classified into two distinct groups -- one that has **month** as the most granular time period and the other which has **microsecond** as the most granular...
In the Stack Overflow question [here](https://stackoverflow.com/q/52458374/2144390) the user is attempting to use a `pyodbc.Binary` object. My answer to the question shows that there is no need to use that object...
This isn't an issue as such, more of a request. It's a bit specific to SQL Server, but are there any plans to implement the ODBC bulk copy functions described...
A question on Stack Overflow regarding pyodbc and SQL_VARIANT got me curious to see if an output converter function might be feasible. I confirmed that, without an output converter function,...
Further to #134, and related to https://github.com/pandas-dev/pandas/issues/30884 I'm adding this as a "wish list" item. Python version 3.8.5 (tags/v3.8.5:580fbb0, Jul 20 2020, 15:43:08) [MSC v.1926 32 bit (Intel)] pyodbc version...
Please first make sure you have looked at: * Documentation: https://github.com/mkleehammer/pyodbc/wiki * Other issues ### Environment To diagnose, we usually need to know the following, including version numbers. On Windows,...
Hello, I'm working with a MSSQL database that uses DATETIMEOFFSET's for date storage. However the type is unsupported, would you consider adding it in? DATETIMEOFFSET is an "UPPERCASE" type and...
Please first make sure you have looked at: * Documentation: https://github.com/mkleehammer/pyodbc/wiki * Other issues ### Environment To diagnose, we usually need to know the following, including version numbers. On Windows,...