Re: AS400 and Odd Characters
Ok... that has gotta be an input issue. If that output is the same whether it is output to your program or the terminal, it has to be the input. It almost looks like a terminator (tab/enter/newline/etc) is not being parsed correctly. Each line of text that you showed is from a single database field, correct?
The one that really stands out to me is #1. 2 and 3 look almost where you would expect to see line breaks or tabs. #1 is different in that the special character is in the middle of the word. Honestly, this looks like something I used to see when I worked in a tech support call center. We had a three line box to enter a description of the problem, but in the back end each line of the box actually corresponded to a seperate database field (desc1, desc2, desc3). Just guessing from the way they cut off (PLEASE NOT AS, REQ DATE) is that the case here? The system I worked with before users might hit enter which in the client would put them on the next line, but the database would record it as a single line with a weird character in the middle. Bad input verification maybe?
You know what... this might even be, um, is this a terminal application where each keystroke is sent to the server, then echoed to the screen? Could this issue be caused by the server not processing the backslash character (used for newlines, tabs, and other two-bit characters) properly? Worse, is this a VARCHAR type field?
__________________
The best way to learn anything, is to question everything.
Last edited by wige; 07-02-2009 at 05:06 PM.
|