Response Mapping an SQL response that has CRLF in the data
Hi, I am trying to response map a call to a database, but one of the fields is a text field that contains ordinary Text data with CRLFs in. When this comes out in iTest, the first line of that field is in the correct column, but the other lines appear below with # characters at the front. Is there anyway to get this to be captured as one value for that field? Thanks Dean
No, I don't think there would be any problem in doing so. You can try with increasing the size of the column.
Found an information from mysql reference manual: ------------------ BLOB values are treated as binary strings (byte strings). They have no character set, and sorting and comparison are based on the numeric values of the bytes in column values. TEXT values are treated as nonbinary strings (character strings). They have a character set, and values are sorted and compared based on the collation of the character set. ------------------- So I believe if you increase the column value you can get rid of the trucation problem
Hi udaya, I manage to get this to work, but now I have an issue where iTest truncates the database output with ... and doesnt include all the lines. Is there anyway to stop this? The Database in question is the iTest Test report database. Will changing the column type stop this from working? Thanks Dean
I am not sure but can you check the behavior/response outside mysql client GUI?? Either the following way, you may do it: 1. Create a response filter in itest and try to filter #. (But this will be greedy in nature ) 2. The best way, in the databse with admin login change the respective column type to BLOB rather than Text
Could you please provide the sample response of the field for more understanding about the issue.
4 People are following this question.
