pypyodbc
pypyodbc copied to clipboard
Reading a tiny float (which appears to be expressed in scientific notation in the db) causes a value error
Reading data from a Access 2007 MDB, I found that when reading values like 11022302462516E-16, I get the following stack trace.
Error Traceback (most recent call last): File "C:\Python27\lib\unittest\case.py", line 329, in run testMethod() File "D:\...\tests\test_msaccess.py", line 19, in test_odbc_connect for row in cursor: File "C:\Python27\lib\site-packages\pypyodbc.py", line 1920, in next row = self.fetchone() File "C:\Python27\lib\site-packages\pypyodbc.py", line 1871, in fetchone value_list.append(buf_cvt_func(alloc_buffer.value)) ValueError: could not convert string to float: E-16
Running the same query using pyodbc succeeds.