freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: Brian Bruns <camber AT umcc.ais.org>
- To: TDS Development Group <freetds AT franklin.oit.unc.edu>
- Subject: Re: MONEY datatype
- Date: Tue, 1 Jun 1999 21:52:17 -0400 (EDT)
FYI, this is now partially fixed. 8 byte money values now use the
numeric routines to produce a string, however the opposite case is still
unimplemented (string to DBMONEY/CS_MONEY). SQSH 1.4 works great, but sqsh
1.6/7 takes a big string and converts it to a CS_MONEY value and back
again to test column size (I think that's why).
Anyway, if you are merely trying to print a string value for money
types, everything should now work.
Brian
On Fri, 28 May 1999, Oleg Klimashevsky wrote:
> Does someone fix it:
>
> /*FIX ME -- this will not handle really big money */
> bignum=(unsigned char) src[4]+
> (unsigned char) src[5]*256+
> (unsigned char) src[6]*256*256+
> (unsigned char) src[7]*256*256*256;
> dollars=bignum/10000;
> hundreths=bignum%10000;
> sprintf(dest,"%lu.%02lu",dollars,hundreths/100);
>
- Re: MONEY datatype, Brian Bruns, 06/01/1999
Archive powered by MHonArc 2.6.24.