Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Data storage problems
Hi. I don't know if this is the appropriate place to ask this question, but
here goes.
I have an application that is written in Microsoft Access. It stores it's data in an Oracle database and accesses the data via the Oracle ODBC Driver. Here's the problem. If I enter 1 million (1,000,000) into a field in my system, oracle stores 1.79865E+308. I can enter this from a form or from a query or from opening the linked table directly. If I then attempt to read the value using SQL*Plus, I get 0 returned from Oracle. So, I update the value using an Update command in SQL* Plus. When I read the value back in Access, it is 0.
I then, on a whim, tried to insert 1000001. This worked fine. Why?
Anyway, the field is defined as a FLOAT, data length is 22, precision is 126. I have other numbers in the system that range from 0 to 10,000,000. As far as I can tell, it is only the number 1,000,000 that is causing problems. Any ideas?
Thank you in advance for your assistance. Received on Mon Oct 05 1998 - 09:22:54 CDT