Did you ever try storing the files in an Image data-type? I'm not sure, but I would guess that would not require the files to be converted to text before storing them.
M!ke -----Original Message----- From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005 12:12 AM To: CF-Talk Subject: Re: MSSQL TEXT datatype problem with CF Yeps, you have to enable CLOB retrieval and set a max buffer size to get this to work. Actually, I'm guessing you've might have CLOB turned on already and just not have the buffer set high enough. It's rougly max record size in kBytes. Otherwise it will cut your result off. I had to do it when I was storing PDFs converted from Binary to base64 as long-text strings in a DB table. It worked pretty cool, but only if I had the buffer jacked up to about 1.5MB. Turns out that 30MB of PDF files take up roughly 195MB of space in the DB when encoded and stuffed into a long text field in SQL Server. Then I'd grab the one I wanted and use cfcontent/cfheader to return it as an attachment or inline. Cool test of the technology, but a big consumer of DB space (unless you've got pretty specific needs... a waste.) Laterz, J ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197236 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
