How to insert new line to nvarchar using c# code

Question

I have a table with a field ,description nvarchar(200).

I am inserting string with a lot of lines.

When I take quick watch over the string in visual studio, I can see the string splited over mutile lines as i expected.

line1
line2
line3

But when I insert to database using a stored procedure,all "\n\r" beomes just spaces. When I read from the databse there is no "\n\r"

what can i do?

Is the stored procedure removing char #10 #3 and replacing them with spaces. — rerun, Apr 11 '11 at 17:08

score 14 · Accepted Answer · answered Apr 11 '11 at 17:08

14

It should be stored just fine. When you look through SSMS, it removes the newlines for readability in its grid.

answered Apr 11 '11 at 17:08

Daniel A. White

score 2 · Answer 2 · edited May 23 '17 at 12:29

2

char(13) is CR. For DOS-/Windows-style CRLF linebreaks, you want char(13)+char(10), like:

'This is line 1.' + CHAR(13)+CHAR(10) + 'This is line 2.'

edited May 23 '17 at 12:29

Community

answered Apr 11 '11 at 17:07

Homam

Akram Shahda · Answer 3 · 2011-05-22T15:34:30.330

1

Use CHAR(13)

Refer to: CHAR

edited May 22 '11 at 15:34

answered Apr 11 '11 at 17:09

Akram Shahda

score 0 · Answer 4 · answered Apr 11 '11 at 17:12

0

its best to use System.Environment.NewLine

answered Apr 11 '11 at 17:12

moi_meme

4 Answers4