Re: Storing large text fields ---- urgent help required.

Its not just VB either, if you use the PSQL thing (very descriptive I know) that comes with Oracle, this limits you to 32K as well. This is what is so anoying, that the Long supports 2gig, but only allows you to enter 32 K.

Thanks.

Matt.

Howard J. Rogers <howardjr_at_www.com> wrote in message news:3b95414e_at_news.iprimus.com.au...
> LONGS are deprecated in 8i, but still useable, and they store character
data
> up to 2Gb in size... so why your 100,000-characters can't fit, I can't
> imagine (assuming 1 byte per character, I make that a measly 100K or so
per
> report -but then my maths might be a little rusty). I can only think it
has
> something to do with the way you (or VB) are using them, not their
intrinsic
> limitations.
>
> Regards
> HJR
>
>
> "CME" <support_at_cmesys.demon.co.uk> wrote in message
> news:999619263.17154.0.nnrp-13.c2de4217_at_news.demon.co.uk...
> > Dear all,
> >
> > Sorry for this question, but I need to release in the next week.
> >
> >
> > We have an internally developed reportwriter that stores its reports as
> XML
> > in a database. Historically this data was stored in a column of type
LONG.
> >
> > The average length of characters is about 100,000.
> >
> >
> > We cannot write this amount of text to the field even when trying to
BIND
> > the field.
> >
> > I have also tried a CLOB, but VB does not support this datatype via
ADO..
> >
> >
> > So if anyone could tell me how the hell I am ameant to store this data
> (and
> > initially populating the table with our default reports), I would be
very
> > happy.
> >
> >
> > I have never had any problems using Sybase or SQL Server, but I have
been
> > round in circles for the last two days.
> >
> > Information:
> >
> > We are using Oracle 8i standard edition with ADO 2.6 to VB 6 (sp 5).
> >
> > An example of the SQL would be useful.
> >
> >
> > Matt.
> >
> >
>
>
Received on Wed Sep 05 2001 - 01:25:39 CDT