-----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.
Best regards,
Zac Bedell
-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com>
iQA/AwUBOctpWAraVoMWBwRBEQKs1gCfd1nA+uOjhyFIJIH0e1x7Z74cAaIAn390
VsCvR6QBr5LFJ5viEZdb8L6p
=VKOJ
-----END PGP SIGNATURE-----
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.