[Vtigercrm-developers] decimal type sizes

[Richard Hills]

I don't believe any issues will arise if you edit your database to 
change the column to a smaller limit. I guess however that it is safest 
to keep this a large number for the default install as you never know 
what data people will throw at the system. We definitely have customers 
who would not be able to run their current setups with a limit of 8,2.

On 12/02/13 08:03, Adam Heinz wrote:
> I was just reading up on the storage requirements of the MySQL decimal 
> type [1] while staring at vtiger_inventoryproductrel.  It looks like 
> decimal(8,2) will suit our needs, as that will cover quotes up to 
> $999,999.99 using four bytes.  It looks like the vtiger default is 
> decimal(25,3), which uses twelve bytes.  I recognize that conversion 
> rates for non-US currency might cause larger values in this field than 
> we are accustomed to, but do we really envision the need for 
> 9,999,999,999,999,999,999,999.999 in our price columns?
>
> [1] 
> http://dev.mysql.com/doc/refman/5.0/en/precision-math-decimal-changes.html
>
>
> _______________________________________________
> http://www.vtiger.com/


-- 
Richard Hills
TechnologyWise Ltd, Tauranga, NZ
richard at tw.co.nz
www.technologywise.co.nz
ph: +64 (0)7 571 1060
fax: +64 (0)7 571 1061

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20130212/f8d062f2/attachment.html