>>I looked at the code. There is nothing extra, the text I was passing was
>>
>>"// Comment Test\n\nSUB(BASE G1) \nSUB(FACTORS) \nSUB(2GM1) \nSUB(3+GM1) \nROUND(1.00)"
>>
>>and I got exactly same text back as well. I'll look in the SQL Server now.
>>
>>When I changed Query Output to text it also looks correct to me.
>>
>>So, perhaps there is no problem at all.
>
>I did paste that text into a VarChar(MAX) field and it was saved ok. I was able to display it back into a HTML form as is.
>
>However, in that text, carriage returns are being represented by special characters. Did the user do a carriage return or entered the equivalent in that encoding syntax?
I added a normal line break when entering the top portion of the text. I added two visual line breaks.
I think we do not have a problem in that particular area.
If it's not broken, fix it until it is.
My Blog