NUMBER(1) vs NUMBER

From: Calydae <calydae_at_ifrance.com>
Date: 31 Aug 2001 14:51:47 GMT
Message-ID: <2001831-165147-488378@foorum.com>

Hi all,

We met a pb few days ago : when we insert with ASP code value 1 in a NUMBER(1) column, everything was ok.

Then : select * from table where column = 1 ==> nothing !! and select * from table where column = 0 ==> OK (other lines inserted before)

BUT : select * from table where to_number(column) = 1 ==> OK

I changed column format from NUMBER(1) to NUMBER and everything was Ok.

So : NUMBER(1) != NUMBER ???

Any idea ?

Thanks

---

User of http://www.foorum.com/. The best tools for usenet searching. Received on Fri Aug 31 2001 - 09:51:47 CDT