Professional Web Applications Themes

String or binary data would be truncated error - ASP

So... What is the problem? "J. Muenchbourg" <anonymousdevdex.com> wrote in message news:%23tgFGdYRDHA.2636TK2MSFTNGP10.phx.gbl... > I have a pretty lengthy sql string that basically inserts records into > SQL dbase; every now and then when hitting submit, I get this error: > string or binary Data would be truncated > > and it points to the line that executes my sql statement, which doesnt > tell me enough because the sql string is quite long. > > ??? > Muench > > > > *** Sent via Developersdex [url]http://www.developersdex.com[/url] *** > Don't just participate in USENET...get rewarded for it!...

  1. #1

    Default Re: String or binary Data would be truncated error

    So...

    What is the problem?


    "J. Muenchbourg" <anonymousdevdex.com> wrote in message
    news:%23tgFGdYRDHA.2636TK2MSFTNGP10.phx.gbl...
    > I have a pretty lengthy sql string that basically inserts records into
    > SQL dbase; every now and then when hitting submit, I get this error:
    > string or binary Data would be truncated
    >
    > and it points to the line that executes my sql statement, which doesnt
    > tell me enough because the sql string is quite long.
    >
    > ???
    > Muench
    >
    >
    >
    > *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    > Don't just participate in USENET...get rewarded for it!

    Ivan Demkovitch Guest

  2. #2

    Default Re: String or binary Data would be truncated error

    Inspect each of the values that are being inserted into CHAR/VARCHAR
    columns. At least one of them is too long.

    And you have much more information then we do, obviously, to troubleshoot
    the problem...



    "J. Muenchbourg" <anonymousdevdex.com> wrote in message
    news:#tgFGdYRDHA.2636TK2MSFTNGP10.phx.gbl...
    > I have a pretty lengthy sql string that basically inserts records into
    > SQL dbase; every now and then when hitting submit, I get this error:
    > string or binary Data would be truncated
    >
    > and it points to the line that executes my sql statement, which doesnt
    > tell me enough because the sql string is quite long.
    >
    > ???
    > Muench
    >
    >
    >
    > *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    > Don't just participate in USENET...get rewarded for it!

    Aaron Bertrand - MVP Guest

  3. #3

    Default String or binary data would be truncated error



    Can't find anything in MSDN that explains this ASP error; I'm trying to
    post data into sql dbase, and this error points to the SQL execute line.

    thanks in advance
    Muench

    *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    Don't just participate in USENET...get rewarded for it!
    J. Muenchbourg Guest

  4. #4

    Default Re: String or binary data would be truncated error

    If the column has a maximum length of 10 characters and you try to insert a
    value that is 15 characters, for example, this is the error that you get.

    Ray at home

    "J. Muenchbourg" <jodaddycanada.com> wrote in message
    news:#mkVf8ifDHA.3324TK2MSFTNGP11.phx.gbl...
    >
    > Can't find anything in MSDN that explains this ASP error; I'm trying to
    > post data into sql dbase, and this error points to the SQL execute line.

    Ray at Guest

Similar Threads

  1. String truncated at the first space in the string
    By Serge Myrand in forum ASP Database
    Replies: 5
    Last Post: July 6th, 10:42 AM
  2. #24777 [NEW]: $_GET values truncated at %3C in query string
    By csnyder at chxo dot com in forum PHP Development
    Replies: 0
    Last Post: July 23rd, 08:59 PM
  3. Replies: 0
    Last Post: July 21st, 08:44 AM
  4. error: String or binary data would be truncated.
    By Scott A. Keen in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 11th, 04:40 PM
  5. Replies: 0
    Last Post: July 10th, 03:58 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