Re: LONG vs. VARCHAR2

From: Alan Shein <alanshein_at_erols.com>
Date: Fri, 5 Nov 1999 15:24:03 -0500
Message-ID: <7vvebk$9jn$1@autumn.news.rcn.net>

There are several restrictions on LONGs:

There can be only one LONG per table, LONGs cannot be used as arguments in functions, expressions or in WHERE clauses, so no searching on LONGs is allowed. I don't think there are any performance issues, but perhaps someone else can shed some more light on the topic.

Mac Lazarus <mac.lazarus_at_eds.com> wrote in message news:7vv42v$kth$1_at_news.ses.cio.eds.com...
> 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 - 14:24:03 CST