Re: Varchar2
From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 29 Feb 2008 23:27:20 -0800
Message-ID: <1204356434.943421@bubbleator.drizzle.com>
Date: Fri, 29 Feb 2008 23:27:20 -0800
Message-ID: <1204356434.943421@bubbleator.drizzle.com>
amerar_at_iwc.net wrote:
> Hi,
>
> I'm looking around for opinions.
>
> We're running Oracle 10g, we have the need now for a VARCHAR2 column
> with 6000 characters. I know the standard thing is to create a LOB
> column.
>
> We have not LOB column in our database. I have 2 options here:
>
> The first is to create 2 columns, and, use a function on SELECT and a
> trigger in INSERT to split or concatenate the string.
>
> The second is to use a LOB column, and if I do that, it may have to be
> compatible with PHP, as PHP may be selecting the data......maybe.
>
> So, I'm looking for opinions on people who have done this, or used LOB
> columns, since we never have....
>
> Thanks!
Use a CLOB.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Sat Mar 01 2008 - 01:27:20 CST