Re: Varchar2

From: <>
Date: Sat, 01 Mar 2008 06:39:00 GMT
Message-ID: <8S6yj.7401$li.3086@trnddc06>

<> wrote in message
> 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 column Received on Sat Mar 01 2008 - 00:39:00 CST

Original text of this message