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

    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
    Location
    Ohio
    Posts
    12,592
    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
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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