Web Analytics Made Easy -
StatCounter storing a lot of text in a database - CodingForum


No announcement yet.

storing a lot of text in a database

  • Filter
  • Time
  • Show
Clear All
new posts

  • storing a lot of text in a database

    I have a large amount of text that I need to store in a database so I can edit it online. Each cell can hold up to 250 characters, right? The text that I need to edit is much bigger then 250 characters. How would I go about splitting the text every 250 characters and then storing it into a database and then printing it so it looks fluid?


  • #2
    No. You just need to set a different column-type.

    What db-format are you using? (Or check you helpfunction or documentation for column types and choose the most appropriate --> the smallest that can hold the biggest to be expected value)
    Posting guidelines I use to see if I will spend time to answer your question : http://www.catb.org/~esr/faqs/smart-questions.html


    • #3
      Yes at least in Access there is something called a Memo field type which can hold MUCH more than the typical 255 characters.
      J. Paul Schmidt
      www.Bullschmidt.com - Freelance Web and Database Developer
      www.Bullschmidt.com/DevTip.asp - Classic ASP Design Tips


      • #4
        I agree with the question raf asked... what database are you using?
        Former ASP Forum Moderator - I'm back!

        If you can teach yourself how to learn, you can learn anything. ;)