Found several similar older issues (#380 comes to mind) which should have been corrected in current pyodbc versions.
Environment
- Python : 3.7.6
- pyodbc : 4.0.30
- OS : Windows 10 (64bits)
- DB : 13.0.5102.14
- driver : ODBC Driver 17 for SQL Server
Issue
When activating the fast_executemany flag, some of my inserts raise a pyodbc.ProgrammingError: ('String data, right truncation: length 512 buffer 510', 'HY000')
Nothing unusual about the data sent, a dozen columns, biggest NVARCHAR is 256, some dates and decimals...
I'm trying the various workarounds in the wiki and related issues for temporary tables.
Are those workarounds "clutches" or the actual expected behavior ?
Found several similar older issues (#380 comes to mind) which should have been corrected in current pyodbc versions.
Environment
Issue
When activating the fast_executemany flag, some of my inserts raise a pyodbc.ProgrammingError: ('String data, right truncation: length 512 buffer 510', 'HY000')
Nothing unusual about the data sent, a dozen columns, biggest NVARCHAR is 256, some dates and decimals...
I'm trying the various workarounds in the wiki and related issues for temporary tables.
Are those workarounds "clutches" or the actual expected behavior ?