List:General Discussion« Previous MessageNext Message »
From:Thomas Spahni Date:September 19 2002 4:25pm
Subject:Re: Fractions
View as plain text  
On Wed, 18 Sep 2002, William Martell wrote:

> Can anyone tell me whether we can represent fractions in MySQL 4.0.  I have
> data representing different lengths of objects measured in inches.  Can I
> load this data as is into a field in MySQL or do I have to convert it first
> into an floating point interger or decimal value???

Did you consider storing a fraction using 2 integers? That's the way we
did it many years ago in Forth.

Thomas Spahni
sql, query

FractionsWilliam Martell19 Sep
  • Re: FractionsPaul DuBois19 Sep
    • Re: FractionsMySQL20 Sep
      • RE: FractionsMadscientist20 Sep
        • Re: FractionsMySQL21 Sep
        • Re: FractionsMichael T. Babcock23 Sep
  • Re: FractionsThomas Spahni19 Sep
Re: FractionsMichael T. Babcock19 Sep
Re: FractionsJan Steinman22 Sep