Text will hold something like 2 gigabytes (i don't have the
docs in front of me)... If that's not big enough, storing
it in SQL probably isn't a good idea. Try storing it in a
file and storing the filename in SQL.
As a side note... http://terraserver.microsoft.com stores
satellite images of most of the US. All the images are
stored as BLOBs in a SQL Server cluster.
Norman
Quoting Andrew Scott <[EMAIL PROTECTED]>:
> I need something bigger than 8000, more like double
> this... I have tried
> all these!!
>
>
> > -----Original Message-----
> > From: Craig Dudley [mailto:[EMAIL PROTECTED]]
> > Sent: Saturday, 28 July 2001 1:46 AM
> > To: CF-Talk
> > Subject: RE: SQL 7.0
> >
> > ntext
> >
> > but I prefer to use varchar(8000)
> >
> > -----Original Message-----
> > From: Andrew Scott [mailto:[EMAIL PROTECTED]]
> > Sent: 27 July 2001 16:28
> > To: CF-Talk
> > Subject: SQL 7.0
> >
> >
> > What is the equivalent to memo in ms SQL 7.0, for
> the life of me my
> mind
> > has gone to the fairies on this one!
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
