On Thu, Nov 13, 2014 at 3:38 PM, Simon Slavin <slav...@bigfraud.org> wrote:
> On 13 Nov 2014, at 1:01pm, Dinesh Navsupe <dinesh.navs...@gmail.com> > wrote: > > > My need is 23 decimal digits of precision. We work on complex payout > > calculation engine where in formula outputs are quite large numbers and > > clients do not want to round off. > > [...]. So for 23 digits of accuracy you seem to have a requirement to > manipulate > > 100,000,000,000,000,000,000 > Assuming he means Oracle's NUMBER(23, 10), and given [1], that's more 9,999,999,999,999.9999999999 i.e. "just" under 10 trillion max, with 10 decimal digits accuracy, and not 100 million trillion. FWIW. --DD [1] http://www.orafaq.com/wiki/Number _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
