Skip to Content.
Sympa Menu

freetds - Re: MONEY datatype

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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.

Top of Page