Re: Problem with Oracle float type

Might have something to do with the fact that there's no such data type as 'float' in Oracle. Oracle uses "number", with a precision and scale refiner -for everything.

Regards
HJR <daning_at_my-deja.com> wrote in message news:92ead4$dvp$1_at_nnrp1.deja.com...
> 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 Thu Dec 28 2000 - 02:21:26 CST