On Thu, Nov 13, 2014 at 6:53 PM, RSmith rsm...@rsweb.co.za wrote:
By the way, my Oracle friends should intersect here if need be, but I
believe the oracle method of /decimal(n,m)/ is simply a representation
directive and constraint, there is no native datatype that actually stores
or
On 14 Nov 2014, at 3:42am, James K. Lowden jklow...@schemamania.org wrote:
Simon Slavin slav...@bigfraud.org wrote:
I'm not aware of
any usable libraries which actually support 23,10 outside the world
of physics.
http://www.mpfr.org/#free-sw
I'm sure you're aware of such things.
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
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
[mailto:dinesh.navs...@gmail.com]
Gesendet: Donnerstag, 13. November 2014 13:23
An: sqlite-users@sqlite.org
Betreff: [sqlite] [SQLite] Support for 23,10 Precision number format
Hi,
Does any of SQLite data Type support 23,10 precision format for Number?
If yes, could you pleas help with right data
: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
On 2014/11/13 15:01, Dinesh Navsupe wrote:
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.
I do not think that re-stating your need suffices as a good enough
On Thu, Nov 13, 2014 at 2:33 PM, RSmith rsm...@rsweb.co.za wrote:
On 2014/11/13 15:01, Dinesh Navsupe 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.
If
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.
If you're working with floating-point
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
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
On Thu, Nov 13, 2014 at 4:50 PM, Dinesh Navsupe dinesh.navs...@gmail.com
wrote:
I mean Oracle's NUMBER(23, 10), and given [1], that's more
My need is 23 decimal digits of precision. We work on complex payout
calculation engine where in formula outputs are quite large numbers
and
On 13 Nov 2014, at 3:44pm, Dominique Devienne ddevie...@gmail.com wrote:
On Thu, Nov 13, 2014 at 3:38 PM, Simon Slavin slav...@bigfraud.org wrote:
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
On 2014/11/13 19:06, Simon Slavin wrote:
On Thu, Nov 13, 2014 at 3:38 PM, Simon Slavin slav...@bigfraud.org wrote:
100,000,000,000,000,000,000
But he's using the field to store an amount of money in. So why ask for
anything with ten places after the decimal point ? No genuine currency
of SQLite Database
Betreff: Re: [sqlite] [SQLite] Support for 23,10 Precision number format
On 13 Nov 2014, at 3:44pm, Dominique Devienne ddevie...@gmail.com wrote:
On Thu, Nov 13, 2014 at 3:38 PM, Simon Slavin slav...@bigfraud.org wrote:
100,000,000,000,000,000,000
Assuming he means
On Thu, 13 Nov 2014 14:38:10 +
Simon Slavin slav...@bigfraud.org wrote:
In summary, if you need ultimate precision, use integers. If not,
use 64-bit IEEE-571 like everyone else does without being sued. If
you somehow really need 23,10 maths, then you're going to have to
write your own
16 matches
Mail list logo