[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
Re: Re[2]: [stellation-res] Oracle backend!
|
On Wednesday 24 July 2002 09:41 am, Marco Qualizza wrote:
> > On Wednesday 24 July 2002 05:48 am, Ringo De Smet wrote:
> >> Hello,
>
> <snip>
>
> >> 1) For the long string, I have used Oracle's VARCHAR(2000). If my
> >> colleague has informed me well, this seems to be the largest size
> >> possible. In the DB2 version, it was put on 16000, so I will have to
> >> look into this further.
> >
> > They really don't support a varchar longer that 2K?
>
> Actually, I believe that the Oracle limit (at least in 8i) is
> VARCHAR(4000) -- after that you have to start using CLOBs.
4K is a lot better than 2K for the lines table, if it will work. Most of
the time, clumped lines will be smaller than that.
-Mark
--
Mark Craig Chu-Carroll, IBM T.J. Watson Research Center
*** The Stellation project: Advanced SCM for Collaboration
*** http://www.eclipse.org/stellation
*** Work Email: mcc@xxxxxxxxxxxxxx ------- Personal Email: markcc@xxxxxxxxxxx
