grace wrote: > > hi gurus, > > wat kind of data can be keep in a blob, clob or nclob? eg. picture image > must be kept using clob only... pls give examples and some sample > programs(forms or report) that actually use them. > > Best regards, > Grace Lim > Suy Sing Comm'l Corp. > 632-2474134 >
LOBs are used to store values which are bigger than the 4,000 character limit of varchars and raws. I think that a good criterion would be how you would transfer the data using ftp; BLOB (Binary LOB) is for anything which reaches the other end corrupted when you have forgotten to say 'binary' - images, typically, which should not be stored as CLOBs, but also say Word documents. CLOBs are for anything you would transfer as 'ASCII'. NCLOBs are chiefly for text which uses multibyte characters - If you have to store text in Chinese or Tamil (I guess Malay would be OK in CLOBs), a NCLOB is probably what you need. Do not forget BFILEs, externally stored LOBs (in plain English, references to files). For many applications, they may be more appropriate than the full-blown, Oracle-stored LOB. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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).
