Re: wat kind of data can be keep in blob,clob,nclob

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: sfaroult_at_oriole.com

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: ListGuru_at_fatcity.com (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).