Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Storing single numbers in the database

Re: Storing single numbers in the database

From: Sandra Becker <sbecker6925_at_gmail.com>
Date: Tue, 5 Jun 2007 13:04:59 -0600
Message-ID: <3c5f7820706051204m28492374t67ed36c2cfd8c2db@mail.gmail.com> 





Paul,



The developer believes that numbers are just characters, same as letters,
ergo they are treated the same way in the database.  I know that the values
are stored with different types, but beyond that, I don't know what issues
could bite me.  I have seen code for other columns defined as CHAR or
VARCHAR2 that use <, >, and <> to pull the desired rows.  Would this be
relevant to the discussion as well?



Sandy





>  The developer doesn't want to translate?  What, he thinks 0 and 1 are

> letters?

>

>



--
http://www.freelists.org/webpage/oracle-l


Received on Tue Jun 05 2007 - 14:04:59 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US