List:General Discussion« Previous MessageNext Message »
From:Tobias Rischer Date:April 21 1999 7:59am
Subject:Re: bc math support in MySQL?
View as plain text  
|   A neater approach than BCD (which is just silly) would be a data type
|   which is fixed point, you specify the denominator.  So, if you are dealing
|   with currency, you might want 4 decimal places, so set the denominator to
|   10000.

This sounds like a good idea to me, probably even 

|   
|   If you are dealing with old english currency (unlikely :-) then you want
|   the denominator to be 240.
|   
|   Essentially, this should be implemented simply as an integer, with an
|   automatic scale on the IO routines.
|   
|   Alternatively, simply use an integer, and do the scaling in your
|   middleware! ;)
|   
|   CREATE TABLE (a FIXED(10000));
|   
|   or some such.
|   
|   Jules
|    
|   /----------------+-------------------------------+---------------------\
|   |  Jelibean aka  | jules@stripped         |  6 Evelyn Rd	       |
|   |  Jules aka     | jules@stripped              |  Richmond, Surrey   |
|   |  Julian Bean   | jmlb2@stripped        |  TW9 2TF *UK*       |
|   +----------------+-------------------------------+---------------------+
|   |  War doesn't demonstrate who's right... just who's left.             |
|   |  When privacy is outlawed... only the outlaws have privacy.          |
|   \----------------------------------------------------------------------/
|   
|   
|   ---------------------------------------------------------------------
|   Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
|   posting. To request this thread, e-mail mysql-thread2113@stripped
|   
|   To unsubscribe, send a message to the address shown in the
|   List-Unsubscribe header of this message. If you cannot see it,
|   e-mail mysql-unsubscribe@stripped instead.
|   
|   


-- 
.............................................
       (_)                     Tobias Rischer
        "==='              tobias@stripped
         " "
...still.loving.gnu..........................
Thread
bc math support in MySQL?jkraai20 Apr
  • Re: bc math support in MySQL?Jules Bean20 Apr
    • Re: bc math support in MySQL?Tobias Rischer21 Apr
      • Re: bc math support in MySQL?Tobias Rischer21 Apr
    • Re: bc math support in MySQL?Tobias Rischer21 Apr
      • Re: bc math support in MySQL?Jules Bean21 Apr
    • Re: bc math support in MySQL?Fred Read21 Apr
Re: bc math support in MySQL?jkraai20 Apr