| Subject | Importing numeric values - How do you keep number a number? |
|---|---|
| Author | data.inspector |
| Post date | 2008-10-27T02:14:58Z |
I am trying to import numeric values produced by others (analytical
laboratories) into my Firebird (1.5) database. The numeric values can
cover many orders of magnitude, but generally have 2 significant
figures. So my values can be values such as 320000, 320, 32, 3.2,
.00032. I need to be able to reproduce these values in reports (so
formats like ##.000 are not desirable), use them in calculations, etc.
I can use a variety of source files TXT,
CSV, Access, etc. for input.
I have been using a Firebird float field, but many time the values
such as 3.2 are stored something like 3.1999995678.
How do I keep a number a number?
laboratories) into my Firebird (1.5) database. The numeric values can
cover many orders of magnitude, but generally have 2 significant
figures. So my values can be values such as 320000, 320, 32, 3.2,
.00032. I need to be able to reproduce these values in reports (so
formats like ##.000 are not desirable), use them in calculations, etc.
I can use a variety of source files TXT,
CSV, Access, etc. for input.
I have been using a Firebird float field, but many time the values
such as 3.2 are stored something like 3.1999995678.
How do I keep a number a number?