Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Mansfield, OH

    Unhappy Unanswered: Display over 256 characters for VARCHAR(3500) field

    Hopefully, someone can help me.
    I am working with a database that contains multiple fields within the tables that are being used for Clinical notes. The fields are defined as VARCHAR(3500). But when I try to extract data (either through Query Analyzer or Crystal Reports), only the first 256 characters are displayed. I ran a query to give me the length of the maximum entry size which returned 2722 characters, yet only 256 are displayed.

    How do I go about extracting ALL of the data from this field? Any help is much appreciated.

    Thanks in advance.

  2. #2
    Join Date
    Jun 2003
    Provided Answers: 1
    In Query Analyzer, select Options from the menu and bump up the maximum output characters, which defaults to 256.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

Posting Permissions

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