Re: LONG vs. VARCHAR2

From: Richard J Woodland <richwoodland_at_interfacefamily.com>
Date: Fri, 05 Nov 1999 16:38:49 -0500
Message-ID: <38234E69.BF9D37B8@interfacefamily.com>

As you imply that you are using this field for 'notes', modifying the column to be LONG is probably not a good idea, if only because you could not search for rows with notes containing particular phrases, and so on.

LONGs are generally more trouble than they are worth, unless you are REALLY desperate.

Mac Lazarus wrote:

> My application that accesses an Oracle database currently saves text in a
> column with a datatype and length of VARCHAR2(2000). There is an
> application need to increase the size of the text.
>
> Does anyone know if there are significant performance considerations and
> additional space considerations with using a LONG vs. using VARCHAR2? The
> other alternatively to the above problem is to use multiple rows so that the
> text can be > 2000.
>
> The Oracle DB is 7.3.4. Most of the notes will be no longer that 3000
> bytes.
>
> TIA,
>
> Mac Lazarus
Received on Fri Nov 05 1999 - 15:38:49 CST