Hi, John. I use Access 2000 and when I need more than 255 characters, I use the "Memo" datatype in Acess...I forget the limit for that datatype, but it's quite large and always enough for everything I've needed...
HTH, Rick -----Original Message----- From: John Munyan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 2:33 AM To: CF-Talk Subject: RE: SQL Text question from a beginner I took a look on msdn and books online and haven't been able to make much sense of the situation. It appears that one can't define their own data type and accessing this data is less than intuitive. Anyone out there figured out a way to retrieve a couple of pages of data from ms sql? Or accomplish the insertion of dynamic text via some other means? Thanks, John -----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 > > > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
