[2005] storing textbox content preserving newlines+ white spaces

[Pirate]

I'm trying to update/insert a record in SQL 2005 perserving all the formatting (like new lines ..etc) . I used datatype "varchar(MAX)" in the database . The update/insert works but for some reason the formatting of the text is ignored.I'm using databinding btw.

[mendhak]

Step through your code till you get to the part where it updates, and try to look at the updatecommand being generated for it. Is the text formatting in there?

How do you know it is not preserving formatting? Newlines appear as \n rather than <br/> so if you're trying to display it again, it won't show up as <br/> unless you perform an explicit replace.

[Pirate]

I don't know how they save documents with rich text content...for the update command , it doesn't tell much ..it contains some paramters.

when i type \n within the text , it shows up as "\n" so it's not interpreted as newline.
I want it to show the output text as i entered it with tabs whitespaces and newlines..etc

Maybe i need to serialize the whole content and save it !