Re: CLOB or not?

From: Marin Dimitrov <marin.dimitrov_at_sirma.bg>
Date: Sat, 23 Mar 2002 03:33:18 -0800
Message-ID: <F001.004318D6.20020323033318@fatcity.com>

• Original Message -----

> Oracle has varchar2 limit of 4000. So basically for
> any columns of over 4000 characters, we need to use
> CLOB(BLOB).
>
> My question is : what's the advantage/disadvantage?
> Any database design issue(I need to have a separate
> tablespace). And those columns will also be accessed
> from web via JDBC calls.
>

we access LOBs via JDBC extensively without any problems

for us the only disadvantage was that u couldn't use normal varchar2 functions and operators on CLOBs but this seems to be resolved in 9i (see "SQL Semantics Support for LOBs" - http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a88879/adl07m12.htm#132015 )

I recommend that you take a look at the "Oracle9i Application Developer's Guide - Large Objects (LOBs)" docs for more clarifications

hth,

    Marin

---

"...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. "

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Marin Dimitrov
  INET: marin.dimitrov_at_sirma.bg

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).

Received on Sat Mar 23 2002 - 05:33:18 CST