> From: John Blayter [mailto:[EMAIL PROTECTED] > 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,
I would tell your DBA that large data types exist for a reason... large data! What is his reasoning for not wanting the text data type used? What is the purpose of the field, will it be searched? Indexed? Is the DBA familiar with "Text In Row" (alleviates the double I/O or text retrieval)... etc... Mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:221144 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
