What steps will reproduce the problem?
1. Read $54871.00 from a Currency field in a Microsoft Access
2. Converted resulting decimal.Decimal to a float, and then printed.
What is the expected output? What do you see instead?
Expected a float: 56871.0
Got a weird corrupted value containing a colon: 54870.:
Reproducible for a small number of other values too.
What version of the product are you using? On what operating system?
pyodbc 3.0.6 (also reproduced on pypyodbc
python 1.7.4
Windows 7
Access 2010 (not reproducible on SQLServer)
Please provide any additional information below.
Described in more detail on StackOverflow:
http://stackoverflow.com/questions/16612301/python-inserts-a-colon-in-a-decimal-number-from-access-via-pyodbc/
This includes more details of the steps taken, and an independent repro of the bug.