pypyodbc icon indicating copy to clipboard operation
pypyodbc copied to clipboard

Reading a tiny float (which appears to be expressed in scientific notation in the db) causes a value error

Open jeblackburn opened this issue 8 years ago • 0 comments

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.

jeblackburn avatar Mar 23 '16 17:03 jeblackburn