It sounds like your 'database guy' has turned his own laziness into your challenge. (Translated: cut his work load and quadrupled yours)I can't think of any reason not to use the text data type when it's best suited for the data in question.
Hopefully he manages the server all together so you can win the 'challenge' and change his mind at the same time... Store the data in a text file, store the name of the file in the database and see if he'd rather use scattered hard drive storage rather than the database that was meant to hold it in the first place. A few hundred text files should help to change his mind. It's almost worth the extra work just to teach him a lesson in data storage. Ps. when he comes around, make him port all the files' data into the shiny new "Text" field. I can think of one or two other useless ways to do this but there's seriously no point what-so-ever. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: John Blayter [mailto:[EMAIL PROTECTED] Sent: Saturday, October 15, 2005 11:54 PM To: CF-Talk Subject: zipping and unzipping a string I am looking for a way to zip and unzip a string without going to the hard drive to perform I/O operations. I have started hacking away at some code but I don't know enough Java to get it working. I have a WDDX packet that can be between 9 - 14K that we want to store in a SQL server database. The database guy has hatred towards using a text data type and has challenged us to find a way to fit a 14K wddx packet into a varchar(8000) field. Any help would be greatly appreciated. Thanks, -- John Blayter email: [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221149 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
