Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Matt 10 posts 70 karma points
    Oct 03, 2013 @ 01:35
    Matt
    0

    String or binary data would be truncated SQL Error

    I have a situation on a current project where we are generating urls > 400 chars and this breaks url tracker.

    I increased the size of the OldUrl, OldUrlQueryString, RedirectUrl to varchar(MAX) and this fixed issue.

    Just wondering why the arbitary limit and whether you could increase in the next release?

    thanks

    Matt

  • Stefan Kip 1606 posts 4098 karma points c-trib
    Dec 11, 2013 @ 14:28
    Stefan Kip
    0

    I'll look into this for the next update, thanks for reporting!

  • Stefan Kip 1606 posts 4098 karma points c-trib
    Dec 11, 2013 @ 16:25
    Stefan Kip
    100

    Fixed in v2.4.1!

  • andrew shearer 409 posts 517 karma points
    Sep 01, 2015 @ 03:50
    andrew shearer
    0

    hi - fixed to what, 1000 chars?

    the default maxlength for a querystring is 2048, so wondering why you didn't at least match that length? thanks

  • Stefan Kip 1606 posts 4098 karma points c-trib
    Sep 01, 2015 @ 06:58
    Stefan Kip
    0

    Yes, fixed to 1000 chars.
    The reason? I thought it would be enough and a bigger column would use more space.
    I guess you have some ideas about this?

  • andrew shearer 409 posts 517 karma points
    Sep 02, 2015 @ 03:25
    andrew shearer
    0

    hi - my suggestion would be to match the asp.net default as mentioned here https://msdn.microsoft.com/en-us/library/system.web.configuration.httpruntimesection.maxquerystringlength(v=vs.110).aspx

    "The maximum length of the query string, in number of characters. The default is 2048. "

  • Stefan Kip 1606 posts 4098 karma points c-trib
    Sep 02, 2015 @ 08:02
    Stefan Kip
    0

    And there are no downsides to enlarge the column size?

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies