Professional Web Applications Themes

varchar truncated at 255 characters - Microsoft SQL / MS SQL Server

i have a SP that builds a t-sql script. I use a varchar variable to build the script. I have declared the variable as varchar(8000). When I run the debugger, this variable gets truncated to 255 characters. Any ideas? SQL 2000, SP2 on a Windows 2000 SP3...

  1. #1

    Default varchar truncated at 255 characters

    i have a SP that builds a t-sql script. I use a varchar
    variable to build the script. I have declared the
    variable as varchar(8000). When I run the debugger, this
    variable gets truncated to 255 characters. Any ideas?

    SQL 2000, SP2 on a Windows 2000 SP3
    tim Guest

  2. #2

    Default Re: varchar truncated at 255 characters

    You can change this default behavior in "Options".

    "tim" <timclasslink2000.com> a écrit dans le message de news: 096601c340c0$25726ba0$a001280aphx.gbl...
    > i have a SP that builds a t-sql script. I use a varchar
    > variable to build the script. I have declared the
    > variable as varchar(8000). When I run the debugger, this
    > variable gets truncated to 255 characters. Any ideas?
    >
    > SQL 2000, SP2 on a Windows 2000 SP3
    Guest

  3. #3

    Default Re: varchar truncated at 255 characters

    [url]www.aspfaq.com/2272[/url]



    "tim" <timclasslink2000.com> wrote in message
    news:096601c340c0$25726ba0$a001280aphx.gbl...
    > i have a SP that builds a t-sql script. I use a varchar
    > variable to build the script. I have declared the
    > variable as varchar(8000). When I run the debugger, this
    > variable gets truncated to 255 characters. Any ideas?
    >
    > SQL 2000, SP2 on a Windows 2000 SP3

    Aaron Bertrand - MVP Guest

  4. #4

    Default varchar truncated at 255 characters


    I think this variable is not truncated but your
    window is set as 255 characters.

    Go to Query yzer option and set the character length
    as 8000 you will be able to see the whole string.

    J. Zhang
    >-----Original Message-----
    >i have a SP that builds a t-sql script. I use a varchar
    >variable to build the script. I have declared the
    >variable as varchar(8000). When I run the debugger, this
    >variable gets truncated to 255 characters. Any ideas?
    >
    >SQL 2000, SP2 on a Windows 2000 SP3
    >.
    >
    J. Zhang Guest

  5. #5

    Default Re: varchar truncated at 255 characters

    Thx.
    >-----Original Message-----
    >You can change this default behavior in "Options".
    >
    >"tim" <timclasslink2000.com> a écrit dans le message de
    news: 096601c340c0$25726ba0$a001280aphx.gbl...
    >> i have a SP that builds a t-sql script. I use a
    varchar
    >> variable to build the script. I have declared the
    >> variable as varchar(8000). When I run the debugger,
    this
    >> variable gets truncated to 255 characters. Any ideas?
    >>
    >> SQL 2000, SP2 on a Windows 2000 SP3
    >
    >.
    >
    tim Guest

  6. #6

    Default varchar truncated at 255 characters


    i take it you mean when its printed to the screen?
    if so - adjust the column size in query yser options
    from the default of 256 to 8000 or something. queyr
    anlayser not very good with big text - please sort it out
    ms!
    >-----Original Message-----
    >i have a SP that builds a t-sql script. I use a varchar
    >variable to build the script. I have declared the
    >variable as varchar(8000). When I run the debugger, this
    >variable gets truncated to 255 characters. Any ideas?
    >
    >SQL 2000, SP2 on a Windows 2000 SP3
    >.
    >
    Guest

Similar Threads

  1. #25544 [Ver->Bgs]: Only 255 characters returned from varchar field
    By abies@php.net in forum PHP Development
    Replies: 0
    Last Post: September 16th, 09:37 AM
  2. #25544 [Bgs->Opn]: Only 255 characters returned from varchar field
    By abies@php.net in forum PHP Development
    Replies: 0
    Last Post: September 16th, 07:57 AM
  3. #25544 [Opn->Bgs]: Only 255 characters returned from varchar field
    By iliaa@php.net in forum PHP Development
    Replies: 0
    Last Post: September 15th, 10:32 PM
  4. #25544 [NEW]: Only 255 characters returned from varchar field
    By snick at getart dot ru in forum PHP Development
    Replies: 0
    Last Post: September 15th, 01:38 PM
  5. Replies: 1
    Last Post: August 12th, 03:28 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139