From: forbrich@yahoo.net   
      
   Galina wrote:   
      
   > Hello   
   > I am going to copy a data from MS Access table into Oracle table. One   
   > of fields is memo type and data in this field range from 1 character   
   > to 551 long string. Do I need to create a field type LONG in the   
   > Oracle table to accommodate this data? If not, what field type would   
   > suit best?   
   > Any help will be greatly appreciated.   
   > Thank you.   
   > Galina   
      
   You want type VARCHAR2.   
      
   Since Oracle 8.0 there are limited, if any, circumstances that justify LONG.   
   If the limit of 4000 bytes in VARCHAR2 is not enough, switch to the LOB   
   family (eg: CLOB) not the LONG family.   
      
   Check out Oracle's online documentation at http://docs.oracle.com for more.   
      
   /Hans   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)