Skip to Content.
Sympa Menu

freetds - RE: [freetds] tsql & money datatype

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT peppler.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] tsql & money datatype
  • Date: Mon, 15 Nov 2004 18:02:51 +0100

On Mon, 2004-11-15 at 17:51, Piet De Jong wrote:
> >
> > Try your query with Microsoft's isql.exe, btw. Behold the difference!
> > ;-)
>
> Indeed, Point taken!
> Any 'quick' solution besides casting my queries first to decimal ( 18,4
> ) ?
> Btw I was under the impression that money was a simple alias / type
> being a decimal 18,4

No - money is stored as an 8 byte integer with an implicit decimal
point. numeric/decimal is stored very differently with explicit
precision.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler AT peppler.org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html





Archive powered by MHonArc 2.6.24.

Top of Page