List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:September 19 2002 1:54pm
Subject:Re: Fractions
View as plain text  
At 20:47 -0500 9/18/02, William Martell wrote:
>Hello.
>
>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???

You could store them as strings, but you'd have to interpret them on
the client side, most likely.

>
>Thanks in advance.
>William
Thread
• Re: FractionsCorey Tisdale19 Sep