Sankar - 50 lines at 80 characters per line works out to 4,000 characters, which works out nicely for the Oracle 8 Varchar2 limit. As Naveen and others have pointed out, that is much more convenient for the DBA whenever you have to relocate the table or perform other common operations. I would push the developers to use that datatype.
Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Wednesday, August 28, 2002 8:13 AM To: Multiple recipients of list ORACLE-L First things first. NEVER use a LONG datatype. Oracle says so too but alas uses it in a lot of data dictionary tables. Long has many limitations. The data in VARCHAR2 and CLOBs is stored according to the charcter set defined at the time of database creation. The data in NCLOBs is stored according to the NLS_CHARACTER_SET. Starting 9i the default is UNICODE. What do you mean by 50 lines? How much character is one line? If the maximum text length is not going to exceed 4000 bytes then you should use varchar2, because it accomodates the text and is very easy to use. If the text cannot be accomodated in a varchar2 field then you have to use a CLOB, in which case depending upon the type of data you can choose either CLOB or NCLOB. The problem(or good thing, depending on the situation) with VARCHAR2 fields is that the data is stored alongwith the other data. So it may lead to fragmentation. Alternatively it takes only one read to read the varchar2 data alongwith the other data of the row so it can be benefecial too. depends on how much update against that column you are going to make. HTH Naveen -----Original Message----- Sent: Wednesday, August 28, 2002 5:49 PM To: Multiple recipients of list ORACLE-L Hi, I would like to know which datatype is best to use for storing text data of around 50 lines.The data is basically a variable length user feedback.I am in confusion whether to go for VARCHAR2 or LONG type. Also in CLOB and NCLOB, can somebody clarify me about "CLOBS store single-byte character set data and NCLOBs store fixed-width and varying-width multibyte national chararcter set data(NCHAR data)". Which one is the best to use among VARCHAR2,LONG,CLOB,NCLOB for my requirement Thanks & Regards, Sankar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: P.V.Sankar INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).