<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">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.<br>
<br>
On 12/02/13 08:03, Adam Heinz wrote:<br>
</div>
<blockquote
cite="mid:CAKBdvM8JN0o-o7Ve51KiyRETLzHxbHgdGq7KO+VStFber6057A@mail.gmail.com"
type="cite">
<div dir="ltr">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?
<div>
<br>
</div>
<div>[1] <a moz-do-not-send="true"
href="http://dev.mysql.com/doc/refman/5.0/en/precision-math-decimal-changes.html">http://dev.mysql.com/doc/refman/5.0/en/precision-math-decimal-changes.html</a><br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
<a class="moz-txt-link-freetext" href="http://www.vtiger.com/">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Richard Hills
TechnologyWise Ltd, Tauranga, NZ
<a class="moz-txt-link-abbreviated" href="mailto:richard@tw.co.nz">richard@tw.co.nz</a>
<a class="moz-txt-link-abbreviated" href="http://www.technologywise.co.nz">www.technologywise.co.nz</a>
ph: +64 (0)7 571 1060
fax: +64 (0)7 571 1061</pre>
</body>
</html>