[Valentina] [OFF] Decimal field in mySQL

[Marcus Bointon]

on 18/1/03 18:57, Ruslan Zasukhin at sunshine at public.kherson.ua wrote:

> Hi guys,
> 
> Anybody have use Decimal field in mySQL ?
> 
> I wonder, because by sources, it looks like they do not have implemented
> arithmetic for decimals ???
> 
> You should be able easy check this:
> 
> Make table with f1 and f2 decimal fields.
> Make one records { 3.4  4.8 }
> 
> Now do 
> 
>   SELECT f1 + f2 FROM T
> 
> By sources I see that result will be 7.
> 
> Can anybody check this and confirm ?

Yup, it works correctly for me. Both fields as float type, I get 8.2 (or
close enough). I'm running MySQL 3.23.49.

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

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