Re: Why is VARCHAR2(4000) bad ?

From: Serge Rielau <>
Date: Mon, 21 Jan 2008 22:59:22 -0500
Message-ID: <>

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.


Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Received on Mon Jan 21 2008 - 21:59:22 CST

Original text of this message