At 10:14 AM 9/22/00 -0400, you wrote:
>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
> > What is the max size of text that I can insert into an
> > SQL database and is there a way to make an unlimited
> > size available? What I am trying to do is insert word
> > document converted to html(2000 so they are huge) to make
> > a database of procedures here at work. They can be
> > pretty huge, so the database has to be able to handle
> > anything.
>
>I assume you mean MS SQL Server 7.0?
>
>If so, making the field type 'text' should give you something like
>several gigs per field. If you make them 'varchar', you're limited
>to 8000 chars.
>
>If I recall right, CF needs to be gently tweaked to enable large text
>retrieval. Out-of-box, I think it's limited to 65536 chars. Don't
>quote me on that, tho...
>
>In any case, making the field type 'text' will give you essentially
>unlimited storage (up to available drive space). If it's an issue,
>and you need to know the exact size limit, I can look it up for you.
>I'm just too lazy to go get the book off the shelf & look right
>now... Suffice to say it's a LOT.
However, there is a 4k limit for SQL insert and update. If you run into
this problem and you are using CF Server 4.5(.1), look into using
cfprocparam. If you are running 4.x and you can't find the stored procedure
I have previously posted to handle this, let me know off list and I'll post
it to the list again. It should be in the archives in more than one place.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
