text or varchar datatype?

Results 1 to 2 of 2

Thread: text or varchar datatype?

  1. #1
    Join Date
    Dec 1969

    Default text or varchar datatype?

    The text being stored in the database will be between 100 and 7000 characters in length. I know varchar can handle these, but is it ALWAYS more efficient than the text datatype? I'm certain it would be for something consisting of just a few hundred characters or less, but how about something upwards of 5000? I'm sure the difference comes down to nanoseconds or something insignificant, but I'm wondering if anyone knows.

  2. #2
    Join Date
    Dec 1969

    Default have you checked books online?

    the SQL Server docs have extensive documentation on one or the other...<BR><BR>j<BR>http://www.atrax.ws/

Posting Permissions

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