Results 1 to 2 of 2

Thread: varchar is truncated in query Analyzer ?

  1. #1
    Nisha Guest

    varchar is truncated in query Analyzer ?


    Hi,
    When I insert a varchar greater than size 256 through Query Analyzer and retrieves it back, it shows only the first 256 part of it. Is ther any server seetings I have to alter to incorporate bigger varchar values ? does anybody have any ideas?
    Thanx,
    Nisha

  2. #2
    Jagan Rao Guest

    varchar is truncated in query Analyzer ? (reply)

    From your Query Analyzer, Select "Query", "Current connection options", "Advanced" tabs. Change the value for Maximum Characters per column and then apply.

    Jagan Rao

Posting Permissions

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