[sqlite] [SQLite] Support for 23,10 Precision number format

2014-11-13 Thread Dinesh Navsupe
Hi,

Does any of SQLite data Type support 23,10 precision format for Number?

If yes, could you pleas help with right data type or approach to achieve
this.

If No, then is there something that can be added to SQLite and how quickly?

Thanks,
Dinesh Navsupe
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] [SQLite] Support for 23,10 Precision number format

2014-11-13 Thread Dinesh Navsupe
Hi,

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.

We want to use SQLite for local disk data store and calculations.

Thanks,
Dinesh Navsupe

On Thu, Nov 13, 2014 at 6:14 PM, Simon Slavin <slav...@bigfraud.org> wrote:

>
> On 13 Nov 2014, at 12:23pm, Dinesh Navsupe <dinesh.navs...@gmail.com>
> wrote:
>
> > Does any of SQLite data Type support 23,10 precision format for Number?
> >
> > If yes, could you pleas help with right data type or approach to achieve
> > this.
>
> SQL stores REAL numbers in a REAL field which conforms to 64-bit IEEE 754
> (as much as SQL permits).  This allows 16 decimal digits of precision.
>
> You can store numbers of greater precision than that -- by storing them as
> strings or BLOBs.  You just can't have SQLite do its own maths on them.
>
> > If No, then is there something that can be added to SQLite and how
> quickly?
>
> It is unlikely that the developer team would be interested in doing this.
> Given that the source code for SQLite is open, you might want to implement
> them yourself.  However, the test library for having the developer team do
> this this would probably have to be huge.
>
> SQLite4, which is not released yet, uses an 18-digit decimal number with a
> 3-digit base-10 exponent.  It is possible that this might change if you are
> able to produce a good argument for doing so
>
> Simon.
> ___
> 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


Re: [sqlite] [SQLite] Support for 23,10 Precision number format

2014-11-13 Thread Dinesh Navsupe
You are right Dominique.

I mean Oracle's NUMBER(23, 10), and given [1], that's more

9,999,999,999,999.99
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.99
>
> 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