pyodbc returns MS SQL Server money type as float
Michael Wolfe <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
I'm connecting to a SQL Server 2000 database via pyodbc and FreeTDS. I am running a query that returns the sum of a money column. The result is being returned by pyodbc as a float, not a python Decimal. When I run the exact same python code and query against the exact same MSSQL database from Windows (ie, not using FreeTDS), pyodbc returns a python Decimal. There are obviously many differences between the two operating system environments, but I believe the central issue is with FreeTDS. It is entirely possible that I have not configured things quite right. I am curious if this is a known limitation of FreeTDS or if I have just failed to configure something properly. Please note my comfort zone is with Windows and VBA, not Linux and python....so be gentle. Thanks in advance for any insights. -Mike