Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2007
    Location
    Auckland New Zealand
    Posts
    120
    Provided Answers: 1

    Unanswered: Data Types and Usage varchar(max)

    What are the drawbacks with using a varchar max datatype? varchar stretches on insert/edit to fit the required amount of data (yes/no), IM gussing this makes it slower? I don't think I can Avoid using this data type, but should I try to avoid its usage if possible,

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    slower than what other option for large blocks of text?

    go ahead and use it

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    if all you need is n chars, use varchar(n).

    there are lots of reasons not to use varchar(max) if you don't need it. one big one is that you can't use it as a key in any index.

    I would only use varchar(max) where you otherwise would have used text.

Posting Permissions

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