You are right Dominique. I mean Oracle's NUMBER(23, 10), and given [1], that's more
9,999,999,999,999.9999999999 Thanks. On Thu, Nov 13, 2014 at 9:14 PM, Dominique Devienne <ddevie...@gmail.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users