freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

dblib money bug

From: "Mark J. Lilback" <mark AT lilback.com>
To: freetds mailing list <freetds AT franklin.oit.unc.edu>
Subject: dblib money bug
Date: Wed, 8 Aug 2001 18:37:15 -0400

In dblib.c, I'm running into an improper conversion. Talking to SQL Server 7, I'm getting a SYBMONEYN returned with column_size 4, which means it is SYBMONEY4. But dbcoltype is set to always consider a SYBMONEYN to be a SYBMONEY, which is 8 bytes in length.

Here's a patch to fix it:
986c986,989
< return SYBMONEY;
---

if (colinfo->column_size==4)
return SYBMONEY4;
else
return SYBMONEY;

--
__________________________________________________________________________
"The best assumption to have
Mark J. Lilback is that any commonly held
<mark AT lilback.com> belief is wrong." -- Ken Olsen,
http://www.lilback.com/ founder, Digital Equip. Corp.

dblib money bug, Mark J. Lilback, 08/08/2001