Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Location
    Washington D.C.
    Posts
    164

    Unanswered: Data type: Text vs VarChar (10000)

    I have a table that is used to archive communications.
    One of the fields is ComText, I've used the "Text" data type for this field.
    Now my question is if I use a varchar data type with the length of (10000) would it improve performance in any way (specialy for reporting purposes)?

  2. #2
    Join Date
    Apr 2003
    Posts
    30
    The maximum row size is less than 8k. Plus, it is not good to have a very long varchar field, the space usage will be poor.

  3. #3
    Join Date
    Dec 2002
    Location
    Washington D.C.
    Posts
    164
    Thanks for your reply.
    Do you have experience regarding this issue and an Access front end, cause it seems to me that access reports have some trobule printing reports with memo fields, specially when the machine has a low RAM.

Posting Permissions

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