Donald McLean wrote:
I don't think that separate columns for each type of unit would be a
good choice. I agree with Roy that the most straightforward approach
would be to just convert to a standard unit. Where I work this is what
most people (including me) do.
However, if you want an alternate approach, you could store the value
in one column and the units in another.
And as long as you never need to sort on that column, then there is
probably no drawback. Though personally if I didn't need to sort, I
would probably use a string. JScience should cope with parsing and
formatting well enough, and it guarantees no loss in precision.
Daniel
--
Daniel Noll Forensic and eDiscovery Software
Senior Developer The world's most advanced
Nuix email data analysis
http://nuix.com/ and eDiscovery software
