The blob (or long raw in older versions) is only used for a binary attachment field. The long text fields are stored in standard CLOB(s)
Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Greg Elphick Sent: Tuesday, November 21, 2006 5:48 PM To: [email protected] Subject: Oracle blob attachments Hi Listers, Has anyone figured out what compression method is used to store attachments as blobs in Oracle yet. I thought I would use Oracle FTS instead of AR FTS as it wont cost us any extra but it cant create FTS indexes on the compressed text in the column. Thanks in advance _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
