[Valentina] [OFF] Decimal field in mySQL

[Marcus Bointon]

on 20/1/03 15:41, Ruslan Zasukhin at sunshine at public.kherson.ua wrote:

> Marcus, once again,
> 
> If you set f1 and f2 as DECIMAL(10.3)
> 
> And f1 =  3.4  
>   f2 = 4.8
> 
> Then f1 + f2 = 8.2
> 
> Yes?

Yes, though because it's formatted as 10.3, the result is presented as
8.200.

Two other factors that might possibly be affecting this: I'm not using the
latest MySQL (current is 3.23.54), and I'm using phpmyadmin (2.33pl1) to
talk to MySQL, not a command line client.

It's in there somewhere!

Marcus
-- 
Marcus Bointon
Synchromedia Limited: Putting you in the picture

marcus at synchromedia.co.uk | http://www.synchromedia.co.uk