Re: Limit to Field Length in DB

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 16734
interpreted = N
texte = >Is there a limit to the number of characters for any one field in a database?No, but you'll run into a
limit probably around 15K or so. Web browsers weren't really designed to handle huge amounts of text in forms.If you need the entire text of the story to be searchable, then you'll have to put all the text into a database field or fields. But if you just want searchable keywords, then you can leave the stories in files on disk, and just have the keywords and filenames stored in your database.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Limit to Field Length in DB (PCS Technical Support 1998)
  2. Re: Limit to Field Length in DB (Mark Anderson 1998)
  3. Re: Limit to Field Length in DB (grichter@panavise.com (Gary Richter) 1998)
  4. Re: Limit to Field Length in DB (Mark Anderson 1998)
  5. Re: Limit to Field Length in DB (grichter@panavise.com (Gary Richter) 1998)
  6. Re: Limit to Field Length in DB (PCS Technical Support 1998)
  7. Limit to Field Length in DB (Mark Anderson 1998)
>Is there a limit to the number of characters for any one field in a database?No, but you'll run into a limit probably around 15K or so. Web browsers weren't really designed to handle huge amounts of text in forms.If you need the entire text of the story to be searchable, then you'll have to put all the text into a database field or fields. But if you just want searchable keywords, then you can leave the stories in files on disk, and just have the keywords and filenames stored in your database.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ PCS Technical Support

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Permission denied? (2004) Nested tags count question (1997) Memory Leak (2000) Using Cookie for client specific info? (1997) unable to launch acgi in WebCat (1997) WCS Newbie question (1997) WebCatalog can't find database (1997) Newbie questions (1999) Getting total number of items ordered (1997) Dummy Credit Card Number for debug? (1997) RE: Include (1998) WebDNA Threaded Discussions? (2004) HomePage Caution (1997) Mime-Version in email header (1997) Re:appending to the database (1999) suggestions for a Windows based text editor? (2004) Search results templates (1996) Cart -> Date and Time (2004) First postarg not taking in $Commands (1997) How do you hide [math]stuff[/math] (1997)