Re: Long or Clob

Domenico Gambelli wrote:

> Hi,
> I' am developing a new Db schema with Oracle 8.0.5 and I have a doubt to
> decide the type of one text field.
>
> The problem is that this field will be contain a free text ( I don't
> know th size) , and I'm not sure to use a Clob or a long type.
>
> I will use java to retrieve the value from this field, I remember that
> there was some problem with the lobs object into the jdbc driver of
> release 8.0.5.
>
> Can I use the new features of java1.2.2 for the jdbc also with the old
> version of Oracle and not with 8i ?
> Thank for the help!!!

Hi Domenico,

may be a detail table with varchar2 field (to store your text pieces) can solve your problems?

As to me, this way more useful and effective (storage will be more compact and so on).

Regards Alexander Medvedev Received on Wed Oct 04 2000 - 05:43:27 CDT