I am new to web development (if I can call what I am doing web development) and have a sql question and was hoping someone could point me in the right direction. I have put together this data driven website and found access to be insufficient to hold as much text as I wished in a description field. Thus I moved to sql, but am finding the 4000 character limitation for varchar to be a hindrance and not much better than the 255 character limit in access. I found a link a couple minutes ago basically stating I was pretty much limited to 8000 characters no matter the data type I pick save for some concatenation maneuver. So I am wondering how I can just put a blob of text into the database. I can't be the only guy who wants to store a couple pages of text in a field in a database so that it can be queried to populate a web page can I? On it's face it would seem that if I should be able to define my own data type to accommodate my needs? What is the right direction?
Thanks, John ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
