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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.