Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2003
    Posts
    114

    Unanswered: Creating Bulletin Board

    I am writing an asp application that uses sql server 2000 as the back-end db and I want to create a discussion board. I need to know what data type I should use to accomodate a large entry by the user and anything else I should be aware of.

    Thanks!!!

  2. #2
    Join Date
    Dec 2003
    Posts
    454
    VARCHAR -- 8000 characters in length can be stored. otherwise, you need to use TEXT datatype.

  3. #3
    Join Date
    Apr 2003
    Posts
    114
    Thanks!!!

  4. #4
    Join Date
    Dec 2003
    Posts
    454
    If VARCHAR is enough for storing data, do not use TEXT which sometimes causes a problem.

  5. #5
    Join Date
    Apr 2003
    Posts
    114
    yeah, I am only going to go with 5000 characters so I should be fine. Thanks!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •