If there is a need to store more than 8000 bytes, I usually split the text into 8000-byte chunks and insert it into separate rows. Most likely, this becomes a separate table with a sequence field so that it is easy to put back together.
I used to have problems with text datatypes and this is how I got around the issues. I haven't tried it lately, however, so I don't remember why I did it, but it worked quite well. MAD -----Original Message----- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Thursday, November 11, 2004 2:06 PM To: CF-Talk Subject: Re: OT sql2k question Text fields are only limited by the OS's maximum file size. Gigs and gigs. You're thinking of the varchar limit. There's not way to go past the limit on varchars, but you can always use text instead. I hope that made sense. --Ben DRE wrote: > Hi, > I've noted that the text fields in sql 2000 only go out to 8000 chars. > Is there a means to increase this? > > A good resource for these questions would be great as well. > > Thanks. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184031 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54