FreeTDS Development Group

[Michael Peppler <mpeppler AT peppler.org>]

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