Hello, I am storing massive (>15,000) character StringBuffers (basically html files) into a mySQL database...I was wondering if it would be better to use a CLOB to store it in or to use a BLOB? I was thinking CLOB because i could easily get it out of the database back to StringBuffer and use it in my java application. Any thoughts would be much appreciated. Thanks, Nick Ueda
That's what CLOBs are for... Just wondering what's the incentive for storing the whole HTML documents in the database instead of the more common combination of metadata in the database and raw HTML on disk?
Lasse, By saying metadata do you mean a "reference" to the raw html on disk? And by saying raw html do you mean the actual html file? I was just wanting to get these terms straight. In reply to your question: I don't know...storing the content in a StringBuffer is the first thing I thought of. I bet the way you suggested could very well be alot easier. Thanks, Nick Ueda
Joined: Jan 23, 2002
That's exactly what I meant. That's how most people have done it, based on what I've heard.