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

    Unanswered: Large string data

    I have a web site that allows user to enter large strings into a database (comments, etc). What is the best way to do that? Right now I have them limited to 25 characters and the data type is varchar. Is there a better way?

    Thanks!

  2. #2
    Join Date
    Sep 2003
    Location
    Mumbai, India
    Posts
    36
    You may consider using OPENXML.

  3. #3
    Join Date
    Dec 2003
    Posts
    454
    VARCHAR can hold up to 8000 characters. 25 characters is too small for the comments. If you do not want to let user enter more than 8000 characters in the comments, it is better to use VARCHAR. Otherwise, you may change to TEXT. Note that TEXT datatype sometimes cause the problem.

Posting Permissions

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