Post reply

Line Break in Data

  • November 9, 2015 at 12:52 am

    #304990

    Hi Experts,

    Can anyone help me understand how data inserted into database is getting a line break and trailing space?

    If we do a normal insert the data is proper ,its only through application data is having this issue.

    TIA

  • November 9, 2015 at 1:48 am

    #1838478

    Sounds like the application is adding the extra characters to the input string.

  • November 9, 2015 at 2:18 am

    #1838482

    Thanks Anthony

    Is there anyway this can happen?? I mean other than application or code??

  • November 9, 2015 at 2:23 am

    #1838485

    Generally no unless something is intercepting the command and appending the additional.

    My first step would be to find the sproc in question and check that out. If that's clean check the application where the sproc is called, make sure the developers aren't adding the additional as an append to the end of the input string from the user.

  • November 9, 2015 at 3:33 am

    #1838498

    anthony.green (11/9/2015)

    Generally no unless something is intercepting the command and appending the additional.

    My first step would be to find the sproc in question and check that out. If that's clean check the application where the sproc is called, make sure the developers aren't adding the additional as an append to the end of the input string from the user.

    Thanks Anthony.. Will check those.

  • November 9, 2015 at 6:39 am

    #1838536

    There's a textbox in multiline mode bound to your data.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply