Re: Why is VARCHAR2(4000) bad ?
From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Mon, 21 Jan 2008 22:59:22 -0500
Message-ID: <5vl80uF1mff8fU1@mid.individual.net>
>
> Sort of. It's called a CLOB, and is the better way to deal with
> arbitrarily long strings. Dealing with CLOBs can be a little tricky
> since they're proprietary to Oracle and not standard SQL (i.e. you can't
> expect to use them with ODBC etc.) I wouldn't use a CLOB for this purpose.
CLOBs are SQL Standard. The DBMS_LOB package (or whatever it is called) is not, of course.
Date: Mon, 21 Jan 2008 22:59:22 -0500
Message-ID: <5vl80uF1mff8fU1@mid.individual.net>
Walt wrote:
> Harel wrote:
>> Questions: >> - Since we dont know in advance the size we will really need in the >> future, is there a VARCHAR2(*) ?
>
> Sort of. It's called a CLOB, and is the better way to deal with
> arbitrarily long strings. Dealing with CLOBs can be a little tricky
> since they're proprietary to Oracle and not standard SQL (i.e. you can't
> expect to use them with ODBC etc.) I wouldn't use a CLOB for this purpose.
CLOBs are SQL Standard. The DBMS_LOB package (or whatever it is called) is not, of course.
Cheers
Serge
-- Serge Rielau DB2 Solutions Development IBM Toronto LabReceived on Mon Jan 21 2008 - 21:59:22 CST