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

If you are doing something like
  insert into table(longcolumn) values ('long string'); then you aren't hitting a 32KB limit to the LONG it's an SQL (or is it PL/SQL) limit on the string in the insert statement.

I've done my LONGRAW (and CLOB) work in Java so I can't assist with the VB, but I've hit the 32KB limits in SQL like the above but got well over them in a program.

SteveM
"Matthew Barrett" <matt_barrett_at_tesco.net> wrote in message news:<Wqjl7.43$9z1.26091_at_news6-win.server.ntlworld.com>...
> 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 - 10:23:31 CDT