Re: Problem with Oracle float type

Sorry for something is not clear. I can display the correct data by setting "Col A format ..." in SQL plus. the real problem is I use ADO to access the the table, and ADO could only get value as 2.30.

maybe here is not the right place to post this question.

In article <92e3oc$8sd$1_at_nnrp1.deja.com>,   daning_at_my-deja.com wrote:
> Hi all,
>
> I got a problem when insert data to a column with float data type,
 here
> is my steps.
>
> 1. create table m_test (a float);
>
> 2. insert into m_test values(2.2999999999999998);
>
> 3. select * from m_test;
>
> this is what I got
>
> A
> ----------
> 2.3
>
> I dont want Oracle server displays this value to me, I need the value
> 2.2999999999999998, which has been inserted. I believe that the
> 2.2999999999999998 has been stored in the database. because if you do
> select * from m_test where a=2.3, you get nothing. It looks weird.
 Does
> anybody have idea?
>
> I am running Oracle 8.1.6 on NT.
>
> thank you in advance.
>
> daning
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Wed Dec 27 2000 - 21:00:55 CST