This link may be useful to such a discussion: http://speleotrove.com/decimal/
It's been around a long time, so you may already be familiar with it. A project I have been involved with wrote a system based on that reference library storing 34 digit numbers in text fields (with appropriate collations for sorting and indexing, and UDFs for calculations). Obviously not as fast as have CPU support for such decimal numbers, but still not bad. -- Geoff Worboys Telesis Computing Pty Ltd Jim Starkey wrote: > The original Interbase implementation had rational, aka reasonable, > arithmetic semantics. Your example is an excellent example of idiotic > semantics. Borland rewrote the code to conform what they, severely > lacking in working neurons, interrupted the SQL standard to require. > I care very little about official SQL semantics. I care deeply about > getting the wrong answer. Given a choice between SQL semantics > (correctly interpreted), I'd go with right answers every time. > This needs rational thought and careful discussion. Surely there is > some middle ground between SQL and useful. ------------------------------------------------------------------------------ Go from Idea to Many App Stores Faster with Intel(R) XDK Give your users amazing mobile app experiences with Intel(R) XDK. Use one codebase in this all-in-one HTML5 development environment. Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs. http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
