multi line text in varchar(max)

[bookouri]

I know I have to be missing something simple, but I can't figure out what's going on. I have a varchar(max) column I have three or four paragraphs of text I want to copy and paste into the varchar(max) column. I can select the paragraphs and paste them in, but only the first paragraph is stored in the varchar(max) column. The second and third paragraphs just disappear. I have also tried pasting in first one paragraph, then at the end of that paragraph in the column i paste in the second paragraph and so on, but only the text up to the end of the first paragraph is saved to the table. Can anybody point me in the direction to find out what im doing wrong?

 

[simian336]

Pasting? What is your front end?

Simi

 

[bookouri]

sqlserver management studio, just doing a right click on the table and choosing Edit top 200 rows..then click on the appropriate column and past in the text.

 

[simian336]

I don't think paste is inserting anything after a line feed.

Prbably have to use insert with CHAR(10)+ CHAR(13) to get line feeds.

Simi

 

[bookouri]

I'm new to sqlserver, I had to work mostly with oracle data before. Is there some other column format that I should use to let users store a few paragraphs of text. Am I headed in the wrong direction with the varchar data type in sqlserver?