Only 16 bytes are stored in the DB. It's a pointer to a file. :-) --Ben
DRE wrote: > Dooh! I was mislead by the number next to text in the table design > area. I thought that was the max size, it only shows 16! > > Thanks > > DRE > > > On Thu, 11 Nov 2004 15:06:08 -0500, Ben Doom <[EMAIL PROTECTED]> wrote: > >>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:184044 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