It is the pointer that points to the data that is 16 bytes long :) Jeremy
----- Original Message ----- From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, October 01, 2002 1:30 PM Subject: RE: SQL Text question from a beginner > hey, it was late, and I had been looking at cf and xsl code for like 8 > hours > straight...... ;) > be nice. > > ..tony > > Tony Weeg > Senior Web Developer > Information System Design > Navtrak, Inc. > Fleet Management Solutions > www.navtrak.net > 410.548.2337 > > > -----Original Message----- > From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 01, 2002 1:38 AM > 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 > > > > > > > > > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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