My understanding of TEXT type fields is that there is only 16 bytes stored in the database, because the rest of the field's contents are stored elsewhere. And the 16 bytes are only a pointer to it. A TEXT field in SQl can hold up to 2,147,483,647 characters and cannot be used as variables or parameters in stored procedures. Not sure of the exact amount, but it's a WHOLE LOT of info. It's like a MEMO field in Access. A VARCHAR field is limited to 255 characters max, but as I understand it, a TEXT field is unlimited for most practical purposes.
Other than setting up the table, and some considerations of searching large amounts of data, once you set the fields up, you access TEXT fields just the same way you access VARCHAR fields and there is no difference to how you work with them. But hold disk space allocations in mind, so dont just go and set up a whole bunch of TEXT fields rather than defining lengths in VARCHAR fields - you'll find your disk space gets out of control real fast. (or so I've been led to believe) Cheers Mike Kear AFP Webworks Windsor, NSW, Australia >-----Original Message----- >From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] >Sent: Monday, September 30, 2002 10:38 PM >To: CF-Talk >Subject: RE: SQL Text question from a beginner > >A whopping 16 characters? 8^) > >Actually, according to my SQL Server reference, the TEXT datatype can >store >2,147,483,647 bytes. > >-- >Mosh Teitelbaum >evoch, LLC >Tel: (301) 625-9191 >Fax: (301) 933-3651 >Email: [EMAIL PROTECTED] >WWW: http://www.evoch.com/ > > >> -----Original Message----- >> From: Tony Weeg [mailto:[EMAIL PROTECTED]] >> Sent: Tuesday, October 01, 2002 12:11 AM >> To: CF-Talk >> Subject: RE: SQL Text question from a beginner >> >> >> look at the datatype of "text" it holds 16 bytes of data, i believe. >> >> hth >> >> tony >> >> -----Original Message----- >> From: John Munyan [mailto:[EMAIL PROTECTED]] >> Sent: Tuesday, October 01, 2002 12:04 AM >> To: CF-Talk >> Subject: SQL Text question from a beginner >> >> >> 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
