LONG vs. VARCHAR2

From: Mac Lazarus <mac.lazarus_at_eds.com>
Date: Fri, 5 Nov 1999 11:25:38 -0600
Message-ID: <7vv42v$kth$1@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 - 11:25:38 CST