[python-sybase] Numeric conversion failure

[Dominic F. <dom...@gm...>]

Hi,

I'm having a problem retrieving certain numeric values from a Sybase
ASA 8 database using the Python Sybase module with FreeTDS.

Some of the values returned from a simple "select * from foo" query on
a table in this database show up as NumericTypes with a scale and
precision of 0, and throw a "numeric to string conversion failed"
error when you try to do anything with them. The actual values appear
to be currency values, e.g. 5.00. The FreeTDS command-line tool, tsql,
has no trouble with them.

Any idea what the problem might be, and whether a fix might be possible?

Dominic