From: pbrenner@REMOVEMEevolition.com.au   
      
   We have a customer that is encountering a strange situation.   
      
   He has found that if he has a column defined in the DB as a number it only   
   diplays within the first 7 digits. However if he have the same data in a   
   column defined as number(9) there is not problem.   
      
   table tmp_customer (custid1 number(9), custid2 number) values   
   (123456789,123456789)   
   when he selects this data using a ORACLE 9 driver in the connection setup he   
   gets:   
      
   CUSTID1   CUSTID2   
   123456789 1234567   
      
   He has tried this same scenario against and ORACLE 8 DB and have no problem   
      
   Any suggestion on that one ?   
      
   I have been reading the documentation and it is clearly stated that it is up   
   to 38 digit so I guess 7 would be OK.   
      
   I do not know if there is any setting that can affect that ?   
      
   Thanks   
      
   Pascal   
      
      
      
      
      
      
   --   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)