Numeric conversion failure

"Dominic Fox" <[email protected]> Mon, 19 Jun 2006 10:23:11 +0100
Newsgroups gmane.comp.python.sybase
Message-ID <[email protected]>
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