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