NUMERIC default scale behaves differently on Derby & SQL Server

From: Øyvind Harboe (oyvind.harbo..ylin.com)
Date: Fri Aug 08 2008 - 04:20:45 EDT

Next message: Øyvind Harboe: "Re: NUMERIC default scale behaves differently on Derby & SQL Server"

Previous message: Aristedes Maniatis: "Re: hashing, best practices?"
Next in thread: Øyvind Harboe: "Re: NUMERIC default scale behaves differently on Derby & SQL Server"
Reply: Øyvind Harboe: "Re: NUMERIC default scale behaves differently on Derby & SQL Server"
Reply: Andrus Adamchik: "Re: NUMERIC default scale behaves differently on Derby & SQL Server"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

If I set scale to blank (default) or -1, then Derby will round off down
to nearest whole number whereas SQL Server will not.

Is this intentional?

-- 
Øyvind Harboe
http://www.zylin.com/zy1000.html
ARM7 ARM9 XScale Cortex
JTAG debugger and flash programmer

Next message: Øyvind Harboe: "Re: NUMERIC default scale behaves differently on Derby & SQL Server"
Previous message: Aristedes Maniatis: "Re: hashing, best practices?"
Next in thread: Øyvind Harboe: "Re: NUMERIC default scale behaves differently on Derby & SQL Server"
Reply: Øyvind Harboe: "Re: NUMERIC default scale behaves differently on Derby & SQL Server"
Reply: Andrus Adamchik: "Re: NUMERIC default scale behaves differently on Derby & SQL Server"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Fri Aug 08 2008 - 04:21:20 EDT