>>I don't need to support HTML. I just need to preserve line breaks (and tabs and any similar characters). In my quick test the CR was not preserved when saving our HTML into SQL Server. I'll try to debug now to see when the line break is being lost.
>
>Data submitted to the server as usually handled from a specific function, the one that reads that post received. In there, there is probably some parsing to remove unwanted characters.
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.
If it's not broken, fix it until it is.
My Blog